SCCM Query for total count of OS and Service Pack

﹏ヽ暗。殇╰゛Y 2022-10-01 13:49 88阅读 0赞

This SQL query can be used to find the overall count of Operating systems and their Service packs

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

clip\_image002

http://myitforum.com/cs2/blogs/andersonk/archive/2010/01/22/sccm-query-for-os-and-service-pack-with-count.aspx

转载于:https://blog.51cto.com/prain/271300

发表评论

表情：
评论列表 （有 0 条评论，88人围观）

还没有评论，来说两句吧...

相关阅读