SCCM report for OS version

Question

Is there a report in SCCM to get the OS version of clients, the version I said is like Windows 10 21H2, 22H2...not the build number

I would like a report to get all the versions and the number of each version.

Answer 1

Hi, @golden alick

Thank you for posting in Microsoft Q&A forum.

You may try this query:

select v_R_System.Operating_System_Name_and0 as 'Operating System',

v_GS_OPERATING_SYSTEM.BuildNumber0 as 'Build Number',

case

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '22621' then 'Windows 11 22H2'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '22000' then 'Windows 11 21H2'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '19045' then 'Windows 10 22H2'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '19044' then 'Windows 10 21H2'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '19043' then 'Windows 10 21H1'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '19042' then 'Windows 10 20H2'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '19041' then 'Windows 10 2004'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '18363' then 'Windows 10 1909'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '18362' then 'Windows 10 1903'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '17763' then 'Windows 10 1809'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '17134' then 'Windows 10 1803'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '16299' then 'Windows 10 1709'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '15063' then 'Windows 10 1703'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '14393' then 'Windows 10 1607'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '10586' then 'Windows 10 1511'

when v_GS_OPERATING_SYSTEM.BuildNumber0 = '10240' then 'Windows 10 1507'

End as 'Windows 10 Version', Count(*) as 'Total Devices'

from v_r_system

inner join v_gs_operating_system

on v_R_System.ResourceID=v_GS_OPERATING_SYSTEM.ResourceID

where v_R_System.Operating_System_Name_and0 like '%Microsoft Windows NT Workstation 10.0%'

Group by v_R_System.Operating_System_Name_and0,v_GS_OPERATING_SYSTEM.BuildNumber0

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".