automation policy to show count of win7 by site
Ok so i can throw a basic sql code together and use the
where site = 'mysite1' and [os name] like 'windows 7%'
and this will work to give me a count of machines for that site that are win7
but how do you do it where there are say 10 sites?
im ok with basic sql but dont know how to do this one..