Query SCCM to show Windows 10 Version (Ex. Windows 1703)

Today I will share with you how to query very easy SCCM to see all windows 10 versions, example Windows 10 1703 (who is end of support this month October 2019), Windows 10 1709 and so on.
In SCCM we have information’s about the OS build. For example windows 10 1703 semi-annual channel has OS build number 15063.2079
To see the complete list with Windows 10 versions, build number, end of service, etc see this article: https://docs.microsoft.com/en-ie/windows/release-information/

SQL query:

select *  from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.BuildNumber = "<insert build no>"

GUI configuration

windws-10-version-build-number

 

Windows 10 current versions by servicing option

(All dates are listed in ISO 8601 format: YYYY-MM-DD)

Last Updated: 2019-10-03

Semi-Annual Channel

Version Servicing option Availability date OS build Latest revision date End of service: Home, Pro, Pro for Workstation and IoT Core End of service: Enterprise, Education and IoT Enterprise
1903 Semi-Annual Channel 2019-05-21 18362.388 2019-10-03 2020-12-08 2020-12-08 Microsoft recommends
1809 Semi-Annual Channel 2019-03-28 17763.775 2019-10-03 2020-05-12 2021-05-11
1809 Semi-Annual Channel (Targeted) 2018-11-13 17763.775 2019-10-03 2020-05-12 2021-05-11
1803 Semi-Annual Channel 2018-07-10 17134.1040 2019-10-03 2019-11-12 2020-11-10
1803 Semi-Annual Channel (Targeted) 2018-04-30 17134.1040 2019-10-03 2019-11-12 2020-11-10
1709 Semi-Annual Channel 2018-01-18 16299.1421 2019-10-03 End of service 2020-04-14
1709 Semi-Annual Channel (Targeted) 2017-10-17 16299.1421 2019-10-03 End of service 2020-04-14
1703 Semi-Annual Channel 2017-07-11 15063.2079 2019-10-03 End of service 2019-10-08
1703 Current Branch (CB) 2017-04-11 15063.2079 2019-10-03 End of service 2019-10-08


Enterprise and IoT Enterprise LTSB/LTSC editions

Version Servicing option Availability date OS build Latest revision date Mainstream support end date Extended support end date
1809 Long-Term Servicing Channel (LTSC) 2018-11-13 17763.775 2019-10-03 2024-01-09 2029-01-09
1607 Long-Term Servicing Branch (LTSB) 2016-08-02 14393.3243 2019-10-03 2021-10-12 2026-10-13
1507 (RTM) Long-Term Servicing Branch (LTSB) 2015-07-29 10240.18335 2019-10-03 2020-10-13 2025-10-14

Windows 10 release history

Learn more about the contents of Windows 10 updates at Windows 10 Update History.

Version 1903 (OS build 18362)

OS build Availability date Servicing option Kb article
18362.388 2019-10-03 Semi-Annual Channel KB 4524147
18362.387 2019-09-26 Semi-Annual Channel KB 4517211
18362.357 2019-09-23 Semi-Annual Channel KB 4522016
18362.356 2019-09-10 Semi-Annual Channel KB 4515384
18362.329 2019-08-30 Semi-Annual Channel KB 4512941
18362.295 2019-08-13 Semi-Annual Channel KB 4512508
18362.267 2019-07-26 Semi-Annual Channel KB 4505903
18362.239 2019-07-09 Semi-Annual Channel KB 4507453
18362.207 2019-06-27 Semi-Annual Channel KB 4501375
18362.175 2019-06-11 Semi-Annual Channel KB 4503293
18362.145 2019-05-29 Semi-Annual Channel KB 4497935
18362.116 2019-05-21 Semi-Annual Channel KB 4505057