Wednesday, October 2, 2013

SCCM Report to for Computer Make Model count



The following report will display the computer manufacturer, Model and Number of machines in the environment.
*************************************************************************
SELECT
Manufacturer0 AS Manufacturer,
Model0 AS Model,
COUNT (Model0) AS Count
FROM v_GS_COMPUTER_SYSTEM
GROUP BY Model0, Manufacturer0
ORDER BY Manufacturer0, Model0
*************************************************************************
 More SCCM custom reports can be found here

No comments:

Post a Comment