SELECT Caption0 as 'Operating System',CSDVersion0 as 'Service Pack', COUNT(*) AS 'Count' 
FROM v_GS_OPERATING_SYSTEM,v_R_System 
WHERE v_GS_OPERATING_SYSTEM.Resourceid=v_R_System.Resourceid 
GROUP BY Caption0,CSDVersion0 
ORDER BY Caption0,CSDVersion0   
 
0 comments:
Post a Comment