Query: Count of Machines by Model Type/ Manufacturer for a Specific Site Code

HomeSMSSMS 2003AdministrationQueriesQuery: Count of Machines by Model Type/ Manufacturer for a Specific Site Code

Problem:

I’ve run the Count of Machines by Model Type/ Manufacturer Query but I only want to return counts for a specific site. Can I do this?

Resolution:

Yes you can do this by inserting the following 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