SCCM Report of Operating Systems and Types

Based on Sherry Kissinger’s blog http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx here is the summary report for a list of Processors, OS Type, OS Name, and Computer count. select pr.datawidth0 [Processor bits] , pr.addresswidth0 [OS bits] , sys.Operating_system_Name_and0 [OS Name] ,count(sys.resourceid) [Computers] from v_r_system sys