Count SCCM Client Versions

The following SQL query counts the SCCM client versions by workstations and servers. Note: this will only return count of Windows based clients. If you have Linux/Unix based or Mac, the where clause should be modified to remove Operating_System_Name_and0 criteria. /* Count CM Client Versions by Workstations and Servers */ select ‘Workstations’ as ‘Platform’, Client_Version0,…