Query: Count of Machines by Model Type/ Manufacturer

Problem:

Does anyone have a query that will show me what makes and models of machines I have in my environment and how many there are of each one?

Resolution:

Yes try this:

Select
Manufacturer00 Manufacturer,
Model0 Model,
Count (Model0) Counts
From Computer_System_Data
Group By Model0, Manufacturer00
Order By Manufacturer00

which will give you something like this:

NOTE: If when you run the query you get the following message:

Msg 208, Level 16, State 1, Line 1
Invalid object name 'Computer_System_Data'.

Make sure you are running the Query against your SMS database and NOT Master (which it defaults to).