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

 

Leave a Reply

Your email address will not be published. Required fields are marked *