Count make/model from SCCM

By Rikard Ronnkvist, 2008-12-08 10:26 ConfigMgr

If you are about to certify machines to SCCM and dont know what kind of machines there are.

Here is a query to show you make and model:

SELECT
        Manufacturer0 AS Manufacturer,
        Model0 AS Model,
        COUNT (Model0) AS Count
FROM v_GS_COMPUTER_SYSTEM
GROUP BY Model0, Manufacturer0
ORDER BY Manufacturer0, Model0

Just create a report and paste the query…