Monday, July 15, 2013

SCCM report Query for Computer Manufacturer, Model and total number of machines



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

3 comments:

  1. Valuable blog! This query display the details of computer hardware manufacturers and other hardware details.

    ReplyDelete
  2. really useful... thanks.

    ReplyDelete
  3. SELECT Manufacturer0, Model0, Count(Model0) AS 'Count'
    FROM 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'.

    ReplyDelete