The following query gives details of
computer Manufacturer, model and total number of machines in the environment.
************************************************************
SELECT
Manufacturer0, Model0, Count(Model0) AS 'Count'
FROM
dbo.v_GS_COMPUTER_SYSTEM
GROUP BY
Manufacturer0,Model0
ORDER BY Model0
************************************************************
More SCCM custom reports can be found here
Valuable blog! This query display the details of computer hardware manufacturers and other hardware details.
ReplyDeletereally useful... thanks.
ReplyDeleteSELECT Manufacturer0, Model0, Count(Model0) AS 'Count'
ReplyDeleteFROM dbo.v_GS_COMPUTER_SYSTEM
GROUP BY Manufacturer0,Model0
ORDER BY Model0
Comes back with this error: what am I missing?
Msg 208, Level 16, State 1, Line 1
Invalid object name 'SMS_R_System'.