Monday, 15 August 2011

A SCCM query showing a count of all active systems with their processor type and workstation model

I recently required a list of all active systems with their model number and processor type. Here is the query that will do it.

SELECT     TOP (100) PERCENT COUNT(SYS.Netbios_Name0) AS Count, Processor.Name0 AS Processor, dbo.v_GS_COMPUTER_SYSTEM.Model0 AS [Computer Model]
FROM         dbo.v_R_System AS SYS INNER JOIN
                      dbo.v_GS_PROCESSOR AS Processor ON SYS.ResourceID = Processor.ResourceID INNER JOIN
                      dbo.v_GS_COMPUTER_SYSTEM ON SYS.ResourceID = dbo.v_GS_COMPUTER_SYSTEM.ResourceID
WHERE     (SYS.Obsolete0 = 0) AND (SYS.Client0 = 1)
GROUP BY Processor.Name0, dbo.v_GS_COMPUTER_SYSTEM.Model0

No comments:

Post a Comment