• Added support for the Windows 10 November 2019 Update (1909).
  • Used the new OS_RELEASE field of SMA 10.0
  • You can download a ready to use KACE package here.
  • Added support for the Windows 10 May 2019 Update (1903).
  • Updated the end of support date for the Windows 10 October 2018 Update (1809).
  • Added support for the Windows 10 October 2018 Update (1809).
  • Added a link to the output when there is a unknown build number which redirects you to this article.
  • Updated the report to comply with the latest changes in the Microsoft Windows 10 Modern Lifecycle Policy.
  • Added support for Windows 10 April 2018 Update (1803)
  • Updated to fit the new release policy published by Microsoft
    • All fields are now checking if its an Enterprise or Education release (+6 Month Support)
    • Added the newest End of Support Dates for 1709
  • Added a Common Name Field to Display the Name of the release.
  • Modified Query to have to EOL sections:
    • Calculated EOL Date based on MS 18 month support policy in the Semi-Anual-Channel. 
    • Fixed MS EOL Date
  • Added Windows 10 1709 into the Query.

Note: This query will not work with the Long-Term Servicing Channel

Hi Guys, 

ever wanted to quickly get an overview on which managed Windows 10 device still has support? 
Note: this is not of interest for companies who are running the LTSB Version of Windows 10!
Based on that article i wrote an easy to extend report for you: Windows 10 lifecycle
If you need to know the current build numbers have a look here: Windows 10 Builds

The query will find all machines in the inventory of the current org with operating system name starts with "Microsoft Windows 10".
It will then use the build number to calculate different thinks like a readable OS Version everybody knows (like 1511, 1607 or 1703). 
Also it will check if we gave the build build number an EOL date. If not the query will use the Microsoft default of 18 month (starting with the release date) for a windows 10 build.

And you will get this beautiful report: