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

2 comments:

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

    ReplyDelete
  2. really useful... thanks.

    ReplyDelete