discovering model version instead of product name for laptops

[Ravish Shetty]

we are on madrid and we are performing some discovery scans for laptops after activating the module.

The model info we are getting is the product name via SCCM or discovery...like example Lenovo 20HGS24B00 which the business has a tough time identifying...instead they want the version number like ThinkPad t470s.

is there an OOTB way to get it or has some written a probe or pattern for the same?

[akash_mehta]

So for Lenovo you need to look at the Version0 field in SCCM

//Select portion

v_GS_COMPUTER_SYSTEM_PRODUCT.Version0 as Version

//where  portion

LEFT JOIN v_GS_COMPUTER_SYSTEM_PRODUCT ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_COMPUTER_SYSTEM_PRODUCT.ResourceID

So you will need to modify the data source query and then add it to the mapping.

-Akash

[Ravish Shetty]

thanks, Akash.

I am using the below code and unable to get anything in the version field of import table imp_sccm2012v2_computer_id. could it be that the id that we are using doesn't have access or there is no data in the field or do you see anything wrong in the SQL statement?

SELECT v_gs_computer_system.name0 AS NAME,
v_gs_computer_system.domain0 AS domain,
v_gs_computer_system_product.version0 AS Version,
v_gs_computer_system.model0 AS model,
v_gs_computer_system.manufacturer0 AS manufacturer,
v_gs_computer_system.resourceid,
v_gs_computer_system.username0 AS username,
v_gs_computer_system.numberofprocessors0 AS numberofprocessors,
v_gs_system.systemrole0 AS SystemRole,
v_gs_operating_system.caption0 AS caption,
v_gs_system_enclosure.chassistypes0 AS chassistype,
v_gs_workstation_status.lasthwscan,
v_gs_pc_bios.serialnumber0 AS BIOSSerialNumber,
v_gs_computer_system_product.identifyingnumber0 AS SystemSerialNumber,
v_gs_computer_system_product.uuid0 AS UUIDSerialNumber,
v_gs_system_enclosure.serialnumber0 AS ChassisSerialNumber,
v_gs_baseboard.serialnumber0 AS BaseboardSerialNumber

FROM v_gs_computer_system
LEFT JOIN v_gs_workstation_status
ON v_gs_computer_system.resourceid =
v_gs_workstation_status.resourceid
LEFT JOIN v_gs_system
ON v_gs_computer_system.resourceid = v_gs_system.resourceid
LEFT JOIN v_gs_pc_bios
ON v_gs_computer_system.resourceid = v_gs_pc_bios.resourceid
LEFT JOIN v_gs_operating_system
ON v_gs_computer_system.resourceid =
v_gs_operating_system.resourceid
LEFT JOIN v_gs_computer_system_product
ON v_gs_computer_system.resourceid =
v_gs_computer_system_product.resourceid
LEFT JOIN v_gs_system_enclosure
ON v_gs_computer_system.resourceid =
v_gs_system_enclosure.resourceid
LEFT JOIN v_gs_baseboard
ON v_gs_computer_system.resourceid = v_gs_baseboard.resourceid

[akash_mehta]

I don't see anything wrong with the sql statement overall...did you do a full run of data or a test run of 20 records?  Also, make sure  you are looking at data that has a lenovo manufacturer...