select
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.SystemType0