http://smsug.ca/blogs/garth_jones/archive/2009/01/28/count-of-os-and-bite-size-32-bit-or-64-bit.aspxselect OS.Caption0, CS.SystemType0, Count(*) from dbo.v_GS_COMPUTER_SYSTEM CS Left Outer Join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceId Group by OS.Caption0, CS.SystemType0 Order by OS.Caption0, CS.SystemType0enCommunityServer 2007.1 (Build: 20917.1142)