I wanted a report that would give me a list of computers sorted by Manufacturer, then Model with counts of each.
Here is the fairly simple SQL for the report I came up with.
SELECT CS_MANUFACTURER,CS_MODEL, COUNT(CS_MODEL) AS COUNT FROM MACHINE
GROUP BY CS_MODEL ORDER BY COUNT DESC
I wanted my report to have the most deployed systems at the top, but you can modify the order by to CS_MANUFACTURER,CS_MODEL if you want it ordered by Manufacturer/Model