SCCM Query find All Server count with OS Name
- Recently I was asked to count of servers by OS
- It was quite Challenging as we need to understand the SCCM Structure very well to do the SQL Queries.
- Following are the Queries to fin the Server by OS Name and the count of Servers
SELECT VR.operatingSystem0,COUNT(VR.operatingSystem0) FROM v_R_System AS VR
WHERE VR.operatingSystem0 LIKE '%Windows Server%'
GROUP BY VR.operatingSystem0
