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