This handly little SQL Script will get you a count of all Machines in SCCM by Operating System:

 
select count(operating_system_name_and0 ) as Total , operating_system_name_and0 from v_r_system

group by operating_system_name_and0

orderby Total desc

Discover more from Christine Alifrangis

Subscribe to get the latest posts sent to your email.

Leave a Reply