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
Day: October 21, 2011
declare @collection varchar set @collection = ‘%’ select CS . Name0 , CS . Domain0 , CS . UserName0 , CS . Manufacturer0 , CS . Model0 , CS .
Select Deploymentname , Available , Deadline , cast ( cast ((( cast ( [Compliant] as float ) / ( ISNULL ( [Compliant] , 0 ) + ISNULL ( [Enforcement state