hardware inventory information in System Center Configuration Manager

 SELECT

SYS.Name0 AS 'Computer Name', INV.Manufacturer0 AS 'Manufacturer', INV.Model0 AS 'Model', INV.Processor0 AS 'Processor', INV.TotalPhysicalMemory0 AS 'Total Memory (MB)', INV.NumberOfProcessors0 AS 'Number of Processors', INV.SystemType0 AS 'System Type', INV.BIOSVersion0 AS 'BIOS Version', INV.SerialNumber0 AS 'Serial Number' FROM v_GS_COMPUTER_SYSTEM INV JOIN v_R_System SYS ON INV.ResourceID = SYS.ResourceID WHERE SYS.Client0 = 1

This query will retrieve the following hardware information for all clients: Computer Name Manufacturer Model Processor Total Memory (MB) Number of Processors System Type BIOS Version Serial Number The v_GS_COMPUTER_SYSTEM view provides information about the computer systems and

the v_R_System view provides information about the systems in the SCCM environment.

The JOIN clause is used to associate the data in both views based on the ResourceID column.

The WHERE clause filters the results to only include systems that are clients (Client0 = 1).