Monday, September 13, 2010

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


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


Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home