The CreatorCon Call for Content is officially open! Get started here.

SG-SCCM discovering model names instead of product version for laptops

janindiadoc_1
Tera Expert

‎08-30-2023 05:52 PM

We have SG for SCCM doing the discovery of our hardware CI's. The model information that we are getting is the product name via SCCM for example Lenovo 21CES0B800 which is making tough to identify the model, instead the business want the version number like ThinkPad X1 Yoga Gen 8.

 

janindiadoc_1_0-1693443060364.png

Is there a way to do this from the OOB to display the versions instead of name.

0 Helpfuls
  • 504 Views
2 REPLIES 2

janindiadoc_1
Tera Expert

‎09-11-2023 10:18 PM

Any suggestions please?

0 Helpfuls

MateoBilandzija
Tera Expert

3 weeks ago - last edited 3 weeks ago

Hi, I know this is a really old Question but this worked really well as Custom SQL Statement by several Implementations already.

 

SELECT

v_GS_COMPUTER_SYSTEM.Name0 as name,

v_GS_COMPUTER_SYSTEM.domain0 as domain,

v_GS_COMPUTER_SYSTEM.Manufacturer0 as manufacturer,

CASE WHEN v_GS_COMPUTER_SYSTEM.Manufacturer0 = 'LENOVO' THEN v_GS_COMPUTER_SYSTEM_PRODUCT.Version0 Else v_GS_COMPUTER_SYSTEM.Model0 END AS model,

v_GS_COMPUTER_SYSTEM.ResourceID,

isnull(v_GS_COMPUTER_SYSTEM.UserName0, isnull(v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0,'n/a')) as username,

v_GS_COMPUTER_SYSTEM.NumberOfProcessors0 as numberofprocessors,

v_GS_SYSTEM.SystemRole0 as SystemRole,

v_GS_OPERATING_SYSTEM.Caption0 as caption,

v_GS_OPERATING_SYSTEM.Version0 as Version,

v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 as chassistype,

CONVERT(datetime, SWITCHOFFSET(TODATETIMEOFFSET(WorkstationStatus_DATA.LastHWScan,datepart(tz,SYSDATETIMEOFFSET())),0)) AS 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,

WorkstationStatus_DATA.TimeKey as TimeKey,

v_GS_OPERATING_SYSTEM.TimeStamp as OsTimeStamp,

v_R_System.Creation_Date0 as AssignedDate,

null as OUName,

v_GS_SYSTEM_ENCLOSURE.SMBIOSAssetTag0 as AssetTag

, '03066860c7122010b56243ac95c26027' as connectionid

FROM v_GS_COMPUTER_SYSTEM

LEFT JOIN WorkstationStatus_DATA ON v_GS_COMPUTER_SYSTEM.ResourceID = WorkstationStatus_DATA.MachineID

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

LEFT JOIN v_GS_SYSTEM_CONSOLE_USAGE ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_SYSTEM_CONSOLE_USAGE.ResourceID

LEFT JOIN v_R_System ON v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceID

 

 

Best Regards Mateo

0 Helpfuls