Trying to give something back to the Community...
Some of you may find my "[SMS 2003] Query for Count of Machines by Model Type/ Manufacturer", query a bit unwieldy in big environments. So what if you want to run the same Query but only for a specific Site?
Well you simply insert the line:
Where Name0 Like '<site_code>%'
where '<site_code>' is the Site Code you want to query against. So for example if my Site Code is 'FAQ' then the Query I'd run is:
Select
Manufacturer00 Manufacturer,
Model0 Model,
Count (Model0) Counts
From Computer_System_Data
Where Name0 Like 'FAQ%'
Group By Model0, Manufacturer00
Order By Manufacturer00
No Comments