Trying to give something back to the Community...
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?
ANSWER
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).
No Comments