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
SQL Reporting services have some benefits over the current reporting solution: Provide best in class reporting capability by integrating SQL Reporting Services, with the leading change and configuration management product: SCCM 2007 Enable Ad-hoc reporting – Make it easy for both SCCM administrators, and non administrators to find the information they need to make the … Read more
