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