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.