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:

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

Just create a report and paste the query…