Count make/model from SCCM
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…


 
 