Tagged: Report

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…