SMS Query to count Client Operating Systems per SMS site

select OS.Operating_System_Name_and0, COUNT(*) as 'Client count', inst.SMS_Installed_Sites0
from v_R_System os
inner join v_RA_System_SMSInstalledSites inst on os.resourceid=inst.resourceid
where (os.Client_Type0 = 1 and os.Decommissioned0 = 0) and (os.Obsolete0 = 0 and OS.Operating_System_Name_and0 like '%Workstation%')
GROUP BY Operating_System_Name_and0, SMS_Installed_Sites0

Description:

The Above query gives you the count of different operating systems per each SMS Site.