I just wanted to share the base query I am using to see the client versions i have in my environment and how many of each client. It has three columns: ConfigMgr versions, client version, and count.
SELECT "ConfigMgr Name"=
CASE sys.Client_Version0
WHEN '4.00.6487.2000' THEN 'CM07 SP2 (4.00.6487.2000)'
WHEN '4.00.6487.2157' THEN 'CM07 R3 (4.00.6487.2157)'
WHEN '4.00.6487.2177' THEN 'CM07 R3 KB2516517 (4.00.6487.2177)'
WHEN '4.00.6487.2187' THEN 'CM07 R3 (4.00.6487.2187)'
WHEN '4.00.6487.2188' THEN 'CM07 R3 (4.00.6487.2188)'
WHEN '5.00.0000.0000' THEN 'CM12 RTM (5.00.0000.0000)'
WHEN '5.00.7804.1000' THEN 'CM12 SP1 (5.00.7804.1000)'
WHEN '5.00.7804.1202' THEN 'CM12 SP1 CU1 (5.00.7804.1202)'
WHEN '5.00.7804.1300' THEN 'CM12 SP1 CU2 (5.00.7804.1300)'
WHEN '5.00.7804.1400' THEN 'CM12 SP1 CU3 (5.00.7804.1400)'
WHEN '5.00.7958.1000' THEN 'CM12 R2 (5.00.7958.1000)'
WHEN '5.00.7958.1101' THEN 'CM12 R2 KB 2905002 (5.00.7958.1101)'
WHEN '5.00.7958.1203' THEN 'CM12 R2 CU1 (5.00.7958.1203)'
WHEN '5.00.7958.1303' THEN 'CM12 R2 CU2 (5.00.7958.1303)'
WHEN '5.00.7958.1401' THEN 'CM12 R2 CU3 (5.00.7958.1401)'
WHEN '5.00.7958.1501' THEN 'CM12 R2 CU4 (5.00.7958.1501)'
WHEN '5.00.7958.1604' THEN 'CM12 R2 CU5 (5.00.7958.1604)'
WHEN '5.00.8239.1000' THEN 'CM12 R2 SP1 (5.00.8239.1000)'
WHEN '5.00.8239.1203' THEN 'CM12 R2 SP1 CU1 (5.00.8239.1203)'
WHEN '5.00.8239.1301' THEN 'CM12 R2 SP1 CU2 (5.00.8239.1301)'
WHEN '5.00.8325.1000' THEN 'SCCM 1511 (5.00.8325.1000)'
WHEN '5.00.8325.1104' THEN 'SCCM 1511 KB3118485 (5.00.8325.1104)'
WHEN '5.00.8325.1110' THEN 'SCCM 1511 KB3122677 (5.00.8325.1110)'
WHEN '5.00.8355.1000' THEN 'SCCM 1602 (5.00.8355.1000)'
WHEN '5.00.8412.1000' THEN 'SCCM 1606 (5.00.8412.1000)'
WHEN '5.00.8412.1000' THEN 'SCCM 1606 Early Wave Update KB3180992 (5.00.8412.1204)'
WHEN '5.00.8412.1000' THEN 'SCCM 1702 (5.00.8498.1000)'
WHEN '5.00.8412.1000' THEN 'SCCM 1706 (5.00.8540.1000)'
WHEN '5.00.8458.1000' THEN 'SCCM 1610 (5.00.8458.1000)'
WHEN '5.00.8458.1007' THEN 'SCCM 1610 Update 1 early wave KB3209501 (5.00.8458.1007)'
WHEN '5.00.8540.1005' THEN 'SCCM 1706 Update 1 early wave KB4039380 (5.00.8540.1005)'
WHEN '5.00.8540.1007' THEN 'SCCM 1706 Update 2 early wave KB4036267 (5.00.8540.1007)'
WHEN '5.00.8540.1611' THEN 'SCCM 1706 Update Rollup 1 KB4042949 (5.00.8540.1611)'
WHEN '5.00.8577.1005' THEN 'SCCM 1710 (5.00.8577.1005)'
WHEN '5.00.8577.1108' THEN 'SCCM 1710 Update Rollup 1 KB4057517 (5.00.8577.1108)'
WHEN '5.00.8577.1115' THEN 'SCCM 1710 Update Rollup 2 KB4086143 (5.00.8577.1115)'
WHEN '5.00.8634.1010' THEN 'SCCM 1802 (5.00.8634.1010)'
ELSE 'Other'
END,
sys.Client_Version0 AS [Version],
COUNT(*) [Total]
FROM v_R_System sys
WHERE Client0 = '1'
GROUP BY sys.Client_Version0
CASE sys.Client_Version0
WHEN '4.00.6487.2000' THEN 'CM07 SP2 (4.00.6487.2000)'
WHEN '4.00.6487.2157' THEN 'CM07 R3 (4.00.6487.2157)'
WHEN '4.00.6487.2177' THEN 'CM07 R3 KB2516517 (4.00.6487.2177)'
WHEN '4.00.6487.2187' THEN 'CM07 R3 (4.00.6487.2187)'
WHEN '4.00.6487.2188' THEN 'CM07 R3 (4.00.6487.2188)'
WHEN '5.00.0000.0000' THEN 'CM12 RTM (5.00.0000.0000)'
WHEN '5.00.7804.1000' THEN 'CM12 SP1 (5.00.7804.1000)'
WHEN '5.00.7804.1202' THEN 'CM12 SP1 CU1 (5.00.7804.1202)'
WHEN '5.00.7804.1300' THEN 'CM12 SP1 CU2 (5.00.7804.1300)'
WHEN '5.00.7804.1400' THEN 'CM12 SP1 CU3 (5.00.7804.1400)'
WHEN '5.00.7958.1000' THEN 'CM12 R2 (5.00.7958.1000)'
WHEN '5.00.7958.1101' THEN 'CM12 R2 KB 2905002 (5.00.7958.1101)'
WHEN '5.00.7958.1203' THEN 'CM12 R2 CU1 (5.00.7958.1203)'
WHEN '5.00.7958.1303' THEN 'CM12 R2 CU2 (5.00.7958.1303)'
WHEN '5.00.7958.1401' THEN 'CM12 R2 CU3 (5.00.7958.1401)'
WHEN '5.00.7958.1501' THEN 'CM12 R2 CU4 (5.00.7958.1501)'
WHEN '5.00.7958.1604' THEN 'CM12 R2 CU5 (5.00.7958.1604)'
WHEN '5.00.8239.1000' THEN 'CM12 R2 SP1 (5.00.8239.1000)'
WHEN '5.00.8239.1203' THEN 'CM12 R2 SP1 CU1 (5.00.8239.1203)'
WHEN '5.00.8239.1301' THEN 'CM12 R2 SP1 CU2 (5.00.8239.1301)'
WHEN '5.00.8325.1000' THEN 'SCCM 1511 (5.00.8325.1000)'
WHEN '5.00.8325.1104' THEN 'SCCM 1511 KB3118485 (5.00.8325.1104)'
WHEN '5.00.8325.1110' THEN 'SCCM 1511 KB3122677 (5.00.8325.1110)'
WHEN '5.00.8355.1000' THEN 'SCCM 1602 (5.00.8355.1000)'
WHEN '5.00.8412.1000' THEN 'SCCM 1606 (5.00.8412.1000)'
WHEN '5.00.8412.1000' THEN 'SCCM 1606 Early Wave Update KB3180992 (5.00.8412.1204)'
WHEN '5.00.8412.1000' THEN 'SCCM 1702 (5.00.8498.1000)'
WHEN '5.00.8412.1000' THEN 'SCCM 1706 (5.00.8540.1000)'
WHEN '5.00.8458.1000' THEN 'SCCM 1610 (5.00.8458.1000)'
WHEN '5.00.8458.1007' THEN 'SCCM 1610 Update 1 early wave KB3209501 (5.00.8458.1007)'
WHEN '5.00.8540.1005' THEN 'SCCM 1706 Update 1 early wave KB4039380 (5.00.8540.1005)'
WHEN '5.00.8540.1007' THEN 'SCCM 1706 Update 2 early wave KB4036267 (5.00.8540.1007)'
WHEN '5.00.8540.1611' THEN 'SCCM 1706 Update Rollup 1 KB4042949 (5.00.8540.1611)'
WHEN '5.00.8577.1005' THEN 'SCCM 1710 (5.00.8577.1005)'
WHEN '5.00.8577.1108' THEN 'SCCM 1710 Update Rollup 1 KB4057517 (5.00.8577.1108)'
WHEN '5.00.8577.1115' THEN 'SCCM 1710 Update Rollup 2 KB4086143 (5.00.8577.1115)'
WHEN '5.00.8634.1010' THEN 'SCCM 1802 (5.00.8634.1010)'
ELSE 'Other'
END,
sys.Client_Version0 AS [Version],
COUNT(*) [Total]
FROM v_R_System sys
WHERE Client0 = '1'
GROUP BY sys.Client_Version0