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?
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).