→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Mister_Nobody
Honored Sweeper II

I have created some chart reports.

Source of data is https://learn.microsoft.com/en-us/windows/release-health/release-information

See code of report for Windows 10 in this message:  #M1190

See code of report for Windows Server in this message:  #M1189

 

7 REPLIES 7
Mister_Nobody
Honored Sweeper II

Reports are updated up to July 2024

Mister_Nobody
Honored Sweeper II

Reports are updated up to June 2024

Mercedes_O
Community Manager
Community Manager

Thank you for sharing this with the rest of the Community - we are working on a new section in the Community for Report related topics, which will hopefully make it easier to share these ðŸ˜Š

Mister_Nobody
Honored Sweeper II

Chart: Windows 10 1607 1809 21H2 operating systems builds dates:

*No Windows 10 1507, you can add yourself

 

Select Top 1000000 t1.update_date,
  Count(t1.AssetID) As Total
From (Select Top 1000000 tblAssets.AssetID,
      Case SubString(tblAssets.oscode, 6, 5) + '.' + tblAssets.buildnumber
        When '19044.4651' Then '09.07.2024'
        When '19044.4529' Then '11.06.2024'
        When '19044.4412' Then '14.05.2024'
        When '19044.4291' Then '09.04.2024'
        When '19044.4170' Then '12.03.2024'
        When '19044.4046' Then '13.02.2024'
        When '19044.3930' Then '09.01.2024'
        When '19044.3803' Then '12.12.2023'
        When '19044.3693' Then '14.11.2023'
        When '19044.3570' Then '10.10.2023'
        When '19044.3448' Then '12.09.2023'
        When '19044.3324' Then '08.08.2023'
        When '19044.3208' Then '11.07.2023'
        When '19044.3086' Then '13.06.2023'
        When '19044.2965' Then '09.05.2023'
        When '19044.2846' Then '11.04.2023'
        When '19044.2788' Then '21.03.2023'
        When '19044.2728' Then '14.03.2023'
        When '19044.2673' Then '21.02.2023'
        When '19044.2604' Then '14.02.2023'
        When '19044.2546' Then '19.01.2023'
        When '19044.2486' Then '10.01.2023'
        When '19044.2364' Then '13.12.2022'
        When '19044.2311' Then '15.11.2022'
        When '19044.2251' Then '08.11.2022'
        When '19044.2194' Then '28.10.2022'
        When '19044.2193' Then '25.10.2022'
        When '19044.2132' Then '17.10.2022'
        When '19044.2130' Then '11.10.2022'
        When '19044.2075' Then '20.09.2022'
        When '19044.2006' Then '13.09.2022'
        When '19044.1949' Then '26.08.2022'
        When '19044.1889' Then '09.08.2022'
        When '19044.1865' Then '26.07.2022'
        When '19044.1826' Then '12.07.2022'
        When '19044.1806' Then '28.06.2022'
        When '19044.1767' Then '20.06.2022'
        When '19044.1766' Then '14.06.2022'
        When '19044.1741' Then '02.06.2022'
        When '19044.1708' Then '19.05.2022'
        When '19044.1706' Then '10.05.2022'
        When '19044.1682' Then '25.04.2022'
        When '19044.1645' Then '12.04.2022'
        When '19044.1620' Then '22.03.2022'
        When '19044.1586' Then '08.03.2022'
        When '19044.1566' Then '15.02.2022'
        When '19044.1526' Then '08.02.2022'
        When '19044.1503' Then '25.01.2022'
        When '19044.1469' Then '17.01.2022'
        When '19044.1466' Then '11.01.2022'
        When '19044.1415' Then '14.12.2021'
        When '19044.1387' Then '22.11.2021'
        When '19044.1288' Then '16.11.2021'
        When '17763.6054' Then '09.07.2024'
        When '17763.5936' Then '11.06.2024'
        When '17763.5830' Then '23.05.2024'
        When '17763.5820' Then '14.05.2024'
        When '17763.5696' Then '09.04.2024'
        When '17763.5579' Then '25.03.2024'
        When '17763.5576' Then '12.03.2024'
        When '17763.5458' Then '13.02.2024'
        When '17763.5329' Then '09.01.2024'
        When '17763.5206' Then '12.12.2023'
        When '17763.5122' Then '14.11.2023'
        When '17763.4974' Then '10.10.2023'
        When '17763.4851' Then '12.09.2023'
        When '17763.4737' Then '08.08.2023'
        When '17763.4645' Then '11.07.2023'
        When '17763.4499' Then '13.06.2023'
        When '17763.4377' Then '09.05.2023'
        When '17763.4252' Then '11.04.2023'
        When '17763.4131' Then '14.03.2023'
        When '17763.4010' Then '14.02.2023'
        When '17763.3887' Then '10.01.2023'
        When '17763.3772' Then '20.12.2022'
        When '17763.3770' Then '13.12.2022'
        When '17763.3653' Then '17.11.2022'
        When '17763.3650' Then '08.11.2022'
        When '17763.3534' Then '17.10.2022'
        When '17763.3532' Then '11.10.2022'
        When '17763.3469' Then '20.09.2022'
        When '17763.3406' Then '13.09.2022'
        When '17763.3346' Then '23.08.2022'
        When '17763.3287' Then '09.08.2022'
        When '17763.3232' Then '21.07.2022'
        When '17763.3165' Then '12.07.2022'
        When '17763.3113' Then '23.06.2022'
        When '17763.3046' Then '14.06.2022'
        When '17763.2989' Then '24.05.2022'
        When '17763.2931' Then '19.05.2022'
        When '17763.2928' Then '10.05.2022'
        When '17763.2867' Then '21.04.2022'
        When '17763.2803' Then '12.04.2022'
        When '17763.2746' Then '22.03.2022'
        When '17763.2686' Then '08.03.2022'
        When '17763.2628' Then '15.02.2022'
        When '17763.2565' Then '08.02.2022'
        When '17763.2510' Then '25.01.2022'
        When '17763.2458' Then '18.01.2022'
        When '17763.2452' Then '11.01.2022'
        When '17763.2369' Then '04.01.2022'
        When '17763.2366' Then '14.12.2021'
        When '17763.2330' Then '22.11.2021'
        When '17763.2305' Then '14.11.2021'
        When '17763.2300' Then '09.11.2021'
        When '17763.2268' Then '19.10.2021'
        When '17763.2237' Then '12.10.2021'
        When '17763.2213' Then '21.09.2021'
        When '17763.2183' Then '14.09.2021'
        When '17763.2145' Then '26.08.2021'
        When '17763.2114' Then '10.08.2021'
        When '17763.2091' Then '27.07.2021'
        When '17763.2090' Then '20.07.2021'
        When '17763.2061' Then '13.07.2021'
        When '17763.2029' Then '06.07.2021'
        When '17763.2028' Then '15.06.2021'
        When '17763.1999' Then '08.06.2021'
        When '17763.1971' Then '20.05.2021'
        When '17763.1935' Then '11.05.2021'
        When '17763.1911' Then '22.04.2021'
        When '17763.1879' Then '13.04.2021'
        When '17763.1852' Then '25.03.2021'
        When '17763.1823' Then '18.03.2021'
        When '17763.1821' Then '15.03.2021'
        When '17763.1817' Then '09.03.2021'
        When '17763.1790' Then '16.02.2021'
        When '17763.1757' Then '09.02.2021'
        When '17763.1728' Then '21.01.2021'
        When '17763.1697' Then '12.01.2021'
        When '17763.1637' Then '08.12.2020'
        When '17763.1613' Then '19.11.2020'
        When '17763.1579' Then '17.11.2020'
        When '17763.1577' Then '10.11.2020'
        When '17763.1554' Then '20.10.2020'
        When '17763.1518' Then '13.10.2020'
        When '17763.1490' Then '16.09.2020'
        When '17763.1457' Then '08.09.2020'
        When '17763.1432' Then '20.08.2020'
        When '17763.1397' Then '11.08.2020'
        When '17763.1369' Then '21.07.2020'
        When '17763.1339' Then '14.07.2020'
        When '17763.1294' Then '16.06.2020'
        When '17763.1282' Then '09.06.2020'
        When '17763.1217' Then '12.05.2020'
        When '17763.1192' Then '21.04.2020'
        When '17763.1158' Then '14.04.2020'
        When '17763.1132' Then '30.03.2020'
        When '17763.1131' Then '17.03.2020'
        When '17763.1098' Then '10.03.2020'
        When '17763.1075' Then '25.02.2020'
        When '17763.1039' Then '11.02.2020'
        When '17763.1012' Then '23.01.2020'
        When '17763.973' Then '14.01.2020'
        When '17763.914' Then '10.12.2019'
        When '17763.864' Then '12.11.2019'
        When '17763.832' Then '15.10.2019'
        When '17763.805' Then '08.10.2019'
        When '17763.775' Then '03.10.2019'
        When '17763.774' Then '24.09.2019'
        When '17763.740' Then '23.09.2019'
        When '17763.737' Then '10.09.2019'
        When '17763.720' Then '17.08.2019'
        When '17763.678' Then '13.08.2019'
        When '17763.652' Then '22.07.2019'
        When '17763.615' Then '09.07.2019'
        When '17763.593' Then '26.06.2019'
        When '17763.592' Then '18.06.2019'
        When '17763.557' Then '11.06.2019'
        When '17763.529' Then '21.05.2019'
        When '17763.504' Then '19.05.2019'
        When '17763.503' Then '14.05.2019'
        When '17763.475' Then '03.05.2019'
        When '17763.439' Then '01.05.2019'
        When '17763.437' Then '09.04.2019'
        When '17763.404' Then '02.04.2019'
        When '17763.379' Then '12.03.2019'
        When '17763.348' Then '01.03.2019'
        When '17763.316' Then '12.02.2019'
        When '17763.292' Then '22.01.2019'
        When '17763.253' Then '08.01.2019'
        When '17763.195' Then '19.12.2018'
        When '17763.194' Then '11.12.2018'
        When '17763.168' Then '05.12.2018'
        When '17763.134' Then '13.11.2018'
        When '17763.107' Then '13.11.2018'
        When '17763.55' Then '09.10.2018'
        When '17763.1' Then '02.10.2018'
        When '14393.7159' Then '09.07.2024'
        When '14393.7070' Then '11.06.2024'
        When '14393.6981' Then '14.05.2024'
        When '14393.6897' Then '09.04.2024'
        When '14393.6800' Then '22.03.2024'
        When '14393.6796' Then '12.03.2024'
        When '14393.6709' Then '13.02.2024'
        When '14393.6614' Then '09.01.2024'
        When '14393.6529' Then '12.12.2023'
        When '14393.6452' Then '14.11.2023'
        When '14393.6351' Then '10.10.2023'
        When '14393.6252' Then '12.09.2023'
        When '14393.6167' Then '08.08.2023'
        When '14393.6085' Then '11.07.2023'
        When '14393.5996' Then '23.06.2023'
        When '14393.5989' Then '13.06.2023'
        When '14393.5921' Then '09.05.2023'
        When '14393.5850' Then '11.04.2023'
        When '14393.5786' Then '14.03.2023'
        When '14393.5717' Then '14.02.2023'
        When '14393.5648' Then '10.01.2023'
        When '14393.5582' Then '13.12.2022'
        When '14393.5502' Then '17.11.2022'
        When '14393.5501' Then '08.11.2022'
        When '14393.5429' Then '18.10.2022'
        When '14393.5427' Then '11.10.2022'
        When '14393.5356' Then '13.09.2022'
        When '14393.5291' Then '09.08.2022'
        When '14393.5246' Then '12.07.2022'
        When '14393.5192' Then '14.06.2022'
        When '14393.5127' Then '19.05.2022'
        When '14393.5125' Then '10.05.2022'
        When '14393.5066' Then '12.04.2022'
        When '14393.5006' Then '08.03.2022'
        When '14393.4946' Then '08.02.2022'
        When '14393.4889' Then '17.01.2022'
        When '14393.4886' Then '11.01.2022'
        When '14393.4827' Then '05.01.2022'
        When '14393.4825' Then '14.12.2021'
        When '14393.4771' Then '14.11.2021'
        When '14393.4770' Then '09.11.2021'
        When '14393.4704' Then '12.10.2021'
        When '14393.4651' Then '14.09.2021'
        When '14393.4583' Then '10.08.2021'
        When '14393.4532' Then '29.07.2021'
        When '14393.4530' Then '13.07.2021'
        When '14393.4470' Then '07.07.2021'
        When '14393.4467' Then '08.06.2021'
        When '14393.4402' Then '11.05.2021'
        When '14393.4350' Then '13.04.2021'
        When '14393.4288' Then '18.03.2021'
        When '14393.4283' Then '09.03.2021'
        When '14393.4225' Then '09.02.2021'
        When '14393.4169' Then '12.01.2021'
        When '14393.4104' Then '08.12.2020'
        When '14393.4048' Then '19.11.2020'
        When '14393.4046' Then '10.11.2020'
        When '14393.3986' Then '13.10.2020'
        When '14393.3930' Then '08.09.2020'
        When '14393.3866' Then '11.08.2020'
        When '14393.3808' Then '14.07.2020'
        When '14393.3755' Then '18.06.2020'
        When '14393.3750' Then '09.06.2020'
        When '14393.3686' Then '12.05.2020'
        When '14393.3659' Then '21.04.2020'
        When '14393.3630' Then '14.04.2020'
        When '14393.3595' Then '17.03.2020'
        When '14393.3564' Then '10.03.2020'
        When '14393.3542' Then '25.02.2020'
        When '14393.3504' Then '11.02.2020'
        When '14393.3474' Then '23.01.2020'
        When '14393.3443' Then '14.01.2020'
        When '14393.3384' Then '10.12.2019'
        When '14393.3326' Then '12.11.2019'
        When '14393.3300' Then '15.10.2019'
        When '14393.3274' Then '08.10.2019'
        When '14393.3243' Then '03.10.2019'
        When '14393.3242' Then '24.09.2019'
        When '14393.3206' Then '23.09.2019'
        When '14393.3204' Then '10.09.2019'
        When '14393.3181' Then '17.08.2019'
        When '14393.3144' Then '13.08.2019'
        When '14393.3115' Then '16.07.2019'
        When '14393.3085' Then '09.07.2019'
        When '14393.3056' Then '27.06.2019'
        When '14393.3053' Then '18.06.2019'
        When '14393.3025' Then '11.06.2019'
        When '14393.2999' Then '23.05.2019'
        When '14393.2972' Then '19.05.2019'
        When '14393.2969' Then '14.05.2019'
        When '14393.2941' Then '25.04.2019'
        When '14393.2908' Then '25.04.2019'
        When '14393.2906' Then '09.04.2019'
        When '14393.2879' Then '19.03.2019'
        When '14393.2848' Then '12.03.2019'
        When '14393.2828' Then '19.02.2019'
        When '14393.2791' Then '12.02.2019'
        When '14393.2759' Then '17.01.2019'
        When '14393.2724' Then '08.01.2019'
        When '14393.2670' Then '19.12.2018'
        When '14393.2665' Then '11.12.2018'
        When '14393.2641' Then '03.12.2018'
        When '14393.2639' Then '27.11.2018'
        When '14393.2608' Then '13.11.2018'
        When '14393.2580' Then '18.10.2018'
        When '14393.2551' Then '09.10.2018'
        When '14393.2515' Then '20.09.2018'
        When '14393.2485' Then '11.09.2018'
        When '14393.2457' Then '30.08.2018'
        When '14393.2430' Then '14.08.2018'
        When '14393.2396' Then '30.07.2018'
        When '14393.2395' Then '24.07.2018'
        When '14393.2368' Then '16.07.2018'
        When '14393.2363' Then '10.07.2018'
        When '14393.2339' Then '21.06.2018'
        When '14393.2312' Then '12.06.2018'
        When '14393.2273' Then '17.05.2018'
        When '14393.2248' Then '08.05.2018'
        When '14393.2214' Then '17.04.2018'
        When '14393.2189' Then '10.04.2018'
        When '14393.2156' Then '29.03.2018'
        When '14393.2155' Then '22.03.2018'
        When '14393.2125' Then '13.03.2018'
        When '14393.2097' Then '22.02.2018'
        When '14393.2068' Then '13.02.2018'
        When '14393.2035' Then '17.01.2018'
        When '14393.2007' Then '03.01.2018'
        When '14393.1944' Then '12.12.2017'
        When '14393.1914' Then '27.11.2017'
        When '14393.1884' Then '14.11.2017'
        When '14393.1797' Then '02.11.2017'
        When '14393.1794' Then '17.10.2017'
        When '14393.1770' Then '10.10.2017'
        When '14393.1737' Then '28.09.2017'
        When '14393.1715' Then '12.09.2017'
        When '14393.1670' Then '28.08.2017'
        When '14393.1613' Then '16.08.2017'
        When '14393.1593' Then '08.08.2017'
        When '14393.1537' Then '07.08.2017'
        When '14393.1532' Then '18.07.2017'
        When '14393.1480' Then '11.07.2017'
        When '14393.1378' Then '27.06.2017'
        When '14393.1358' Then '13.06.2017'
        When '14393.1198' Then '09.05.2017'
        When '14393.1066' Then '11.04.2017'
        When '14393.969' Then '20.03.2017'
        When '14393.953' Then '14.03.2017'
        When '14393.693' Then '10.01.2017'
        When '14393.576' Then '13.12.2016'
        When '14393.479' Then '09.12.2016'
        When '14393.447' Then '08.11.2016'
        When '14393.351' Then '27.10.2016'
        When '14393.321' Then '11.10.2016'
        When '14393.222' Then '29.09.2016'
        When '14393.187' Then '20.09.2016'
        When '14393.187' Then '13.09.2016'
        When '14393.105' Then '31.08.2016'
        When '14393.82' Then '23.08.2016'
        When '14393.51' Then '09.08.2016'
        When '14393.10' Then '02.08.2016'
        Else tblAssets.oscode + '.' + tblAssets.buildnumber
      End update_date
    From tblAssets
    Where tblAssets.oscode In ('10.0.14393', '10.0.17763', '10.0.19044') And
      tblAssets.buildnumber <> '0') As t1
Group By t1.update_date
Order By Total Desc

 

Mister_Nobody
Honored Sweeper II

Report for Windows Servers.

Source: https://learn.microsoft.com/en-us/windows/release-health/windows-server-release-info

Chart: Windows Server operating systems builds dates

 

Select Top 1000000 t1.update_date,
  Count(t1.AssetID) As Total
From (Select Top 1000000 tblAssets.AssetID,
      Case SubString(tblAssets.oscode, 6, 5) + '.' + tblAssets.buildnumber
        When '20348.2582' Then '09.07.2024'
        When '20348.2527' Then '11.06.2024'
        When '20348.2461' Then '14.05.2024'
        When '20348.2402' Then '09.04.2024'
        When '20348.2342' Then '22.03.2024'
        When '20348.2340' Then '12.03.2024'
        When '20348.2322' Then '13.02.2024'
        When '20348.2227' Then '09.01.2024'
        When '20348.2159' Then '12.12.2023'
        When '20348.2113' Then '14.11.2023'
        When '20348.2031' Then '10.10.2023'
        When '20348.1970' Then '12.09.2023'
        When '20348.1906' Then '08.08.2023'
        When '20348.1850' Then '11.07.2023'
        When '20348.1787' Then '13.06.2023'
        When '20348.1726' Then '09.05.2023'
        When '20348.1668' Then '11.04.2023'
        When '20348.1607' Then '14.03.2023'
        When '20348.1547' Then '14.02.2023'
        When '20348.1487' Then '10.01.2023'
        When '20348.1368' Then '20.12.2022'
        When '20348.1366' Then '13.12.2022'
        When '20348.1311' Then '22.11.2022'
        When '20348.1251' Then '17.11.2022'
        When '20348.1249' Then '08.11.2022'
        When '20348.1194' Then '25.10.2022'
        When '20348.1131' Then '17.10.2022'
        When '20348.1129' Then '11.10.2022'
        When '20348.1070' Then '20.09.2022'
        When '20348.1006' Then '13.09.2022'
        When '20348.946' Then '16.08.2022'
        When '20348.887' Then '09.08.2022'
        When '20348.859' Then '19.07.2022'
        When '20348.825' Then '12.07.2022'
        When '20348.803' Then '23.06.2022'
        When '20348.768' Then '14.06.2022'
        When '20348.740' Then '24.05.2022'
        When '20348.709' Then '19.05.2022'
        When '20348.707' Then '10.05.2022'
        When '20348.681' Then '25.04.2022'
        When '20348.643' Then '12.04.2022'
        When '20348.617' Then '22.03.2022'
        When '20348.587' Then '08.03.2022'
        When '20348.558' Then '15.02.2022'
        When '20348.524' Then '08.02.2022'
        When '20348.502' Then '25.01.2022'
        When '20348.473' Then '17.01.2022'
        When '20348.469' Then '11.01.2022'
        When '20348.407' Then '05.01.2022'
        When '20348.405' Then '14.12.2021'
        When '20348.380' Then '22.11.2021'
        When '20348.350' Then '09.11.2021'
        When '20348.320' Then '26.10.2021'
        When '20348.288' Then '12.10.2021'
        When '20348.261' Then '27.09.2021'
        When '20348.230' Then '14.09.2021'
        When '20348.202' Then '26.08.2021'
        When '17763.6054' Then '09.07.2024'
        When '17763.5936' Then '11.06.2024'
        When '17763.5830' Then '23.05.2024'
        When '17763.5820' Then '14.05.2024'
        When '17763.5696' Then '09.04.2024'
        When '17763.5579' Then '25.03.2024'
        When '17763.5576' Then '12.03.2024'
        When '17763.5458' Then '13.02.2024'
        When '17763.5329' Then '09.01.2024'
        When '17763.5206' Then '12.12.2023'
        When '17763.5122' Then '14.11.2023'
        When '17763.4974' Then '10.10.2023'
        When '17763.4851' Then '12.09.2023'
        When '17763.4737' Then '08.08.2023'
        When '17763.4645' Then '11.07.2023'
        When '17763.4499' Then '13.06.2023'
        When '17763.4377' Then '09.05.2023'
        When '17763.4252' Then '11.04.2023'
        When '17763.4131' Then '14.03.2023'
        When '17763.4010' Then '14.02.2023'
        When '17763.3887' Then '10.01.2023'
        When '17763.3772' Then '20.12.2022'
        When '17763.3770' Then '13.12.2022'
        When '17763.3653' Then '17.11.2022'
        When '17763.3650' Then '08.11.2022'
        When '17763.3534' Then '17.10.2022'
        When '17763.3532' Then '11.10.2022'
        When '17763.3469' Then '20.09.2022'
        When '17763.3406' Then '13.09.2022'
        When '17763.3346' Then '23.08.2022'
        When '17763.3287' Then '09.08.2022'
        When '17763.3232' Then '21.07.2022'
        When '17763.3165' Then '12.07.2022'
        When '17763.3113' Then '23.06.2022'
        When '17763.3046' Then '14.06.2022'
        When '17763.2989' Then '24.05.2022'
        When '17763.2931' Then '19.05.2022'
        When '17763.2928' Then '10.05.2022'
        When '17763.2867' Then '21.04.2022'
        When '17763.2803' Then '12.04.2022'
        When '17763.2746' Then '22.03.2022'
        When '17763.2686' Then '08.03.2022'
        When '17763.2628' Then '15.02.2022'
        When '17763.2565' Then '08.02.2022'
        When '17763.2510' Then '25.01.2022'
        When '17763.2458' Then '18.01.2022'
        When '17763.2452' Then '11.01.2022'
        When '17763.2369' Then '04.01.2022'
        When '17763.2366' Then '14.12.2021'
        When '17763.2330' Then '22.11.2021'
        When '17763.2305' Then '14.11.2021'
        When '17763.2300' Then '09.11.2021'
        When '17763.2268' Then '19.10.2021'
        When '17763.2237' Then '12.10.2021'
        When '17763.2213' Then '21.09.2021'
        When '17763.2183' Then '14.09.2021'
        When '17763.2145' Then '26.08.2021'
        When '17763.2114' Then '10.08.2021'
        When '17763.2091' Then '27.07.2021'
        When '17763.2090' Then '20.07.2021'
        When '17763.2061' Then '13.07.2021'
        When '17763.2029' Then '06.07.2021'
        When '17763.2028' Then '15.06.2021'
        When '17763.1999' Then '08.06.2021'
        When '17763.1971' Then '20.05.2021'
        When '17763.1935' Then '11.05.2021'
        When '17763.1911' Then '22.04.2021'
        When '17763.1879' Then '13.04.2021'
        When '17763.1852' Then '25.03.2021'
        When '17763.1823' Then '18.03.2021'
        When '17763.1821' Then '15.03.2021'
        When '17763.1817' Then '09.03.2021'
        When '17763.1790' Then '16.02.2021'
        When '17763.1757' Then '09.02.2021'
        When '17763.1728' Then '21.01.2021'
        When '17763.1697' Then '12.01.2021'
        When '17763.1637' Then '08.12.2020'
        When '17763.1613' Then '19.11.2020'
        When '17763.1579' Then '17.11.2020'
        When '17763.1577' Then '10.11.2020'
        When '17763.1554' Then '20.10.2020'
        When '17763.1518' Then '13.10.2020'
        When '17763.1490' Then '16.09.2020'
        When '17763.1457' Then '08.09.2020'
        When '17763.1432' Then '20.08.2020'
        When '17763.1397' Then '11.08.2020'
        When '17763.1369' Then '21.07.2020'
        When '17763.1339' Then '14.07.2020'
        When '17763.1294' Then '16.06.2020'
        When '17763.1282' Then '09.06.2020'
        When '17763.1217' Then '12.05.2020'
        When '17763.1192' Then '21.04.2020'
        When '17763.1158' Then '14.04.2020'
        When '17763.1132' Then '30.03.2020'
        When '17763.1131' Then '17.03.2020'
        When '17763.1098' Then '10.03.2020'
        When '17763.1075' Then '25.02.2020'
        When '17763.1039' Then '11.02.2020'
        When '17763.1012' Then '23.01.2020'
        When '17763.973' Then '14.01.2020'
        When '17763.914' Then '10.12.2019'
        When '17763.864' Then '12.11.2019'
        When '17763.832' Then '15.10.2019'
        When '17763.805' Then '08.10.2019'
        When '17763.775' Then '03.10.2019'
        When '17763.774' Then '24.09.2019'
        When '17763.740' Then '23.09.2019'
        When '17763.737' Then '10.09.2019'
        When '17763.720' Then '17.08.2019'
        When '17763.678' Then '13.08.2019'
        When '17763.652' Then '22.07.2019'
        When '17763.615' Then '09.07.2019'
        When '17763.593' Then '26.06.2019'
        When '17763.592' Then '18.06.2019'
        When '17763.557' Then '11.06.2019'
        When '17763.529' Then '21.05.2019'
        When '17763.504' Then '19.05.2019'
        When '17763.503' Then '14.05.2019'
        When '17763.475' Then '03.05.2019'
        When '17763.439' Then '01.05.2019'
        When '17763.437' Then '09.04.2019'
        When '17763.404' Then '02.04.2019'
        When '17763.379' Then '12.03.2019'
        When '17763.348' Then '01.03.2019'
        When '17763.316' Then '12.02.2019'
        When '17763.292' Then '22.01.2019'
        When '17763.253' Then '08.01.2019'
        When '17763.195' Then '19.12.2018'
        When '17763.194' Then '11.12.2018'
        When '17763.168' Then '05.12.2018'
        When '17763.134' Then '13.11.2018'
        When '17763.107' Then '13.11.2018'
        When '17763.55' Then '09.10.2018'
        When '17763.1' Then '02.10.2018'
        When '14393.7159' Then '09.07.2024'
        When '14393.7070' Then '11.06.2024'
        When '14393.6981' Then '14.05.2024'
        When '14393.6897' Then '09.04.2024'
        When '14393.6800' Then '22.03.2024'
        When '14393.6796' Then '12.03.2024'
        When '14393.6709' Then '13.02.2024'
        When '14393.6614' Then '09.01.2024'
        When '14393.6529' Then '12.12.2023'
        When '14393.6452' Then '14.11.2023'
        When '14393.6351' Then '10.10.2023'
        When '14393.6252' Then '12.09.2023'
        When '14393.6167' Then '08.08.2023'
        When '14393.6085' Then '11.07.2023'
        When '14393.5996' Then '23.06.2023'
        When '14393.5989' Then '13.06.2023'
        When '14393.5921' Then '09.05.2023'
        When '14393.5850' Then '11.04.2023'
        When '14393.5786' Then '14.03.2023'
        When '14393.5717' Then '14.02.2023'
        When '14393.5648' Then '10.01.2023'
        When '14393.5582' Then '13.12.2022'
        When '14393.5502' Then '17.11.2022'
        When '14393.5501' Then '08.11.2022'
        When '14393.5429' Then '18.10.2022'
        When '14393.5427' Then '11.10.2022'
        When '14393.5356' Then '13.09.2022'
        When '14393.5291' Then '09.08.2022'
        When '14393.5246' Then '12.07.2022'
        When '14393.5192' Then '14.06.2022'
        When '14393.5127' Then '19.05.2022'
        When '14393.5125' Then '10.05.2022'
        When '14393.5066' Then '12.04.2022'
        When '14393.5006' Then '08.03.2022'
        When '14393.4946' Then '08.02.2022'
        When '14393.4889' Then '17.01.2022'
        When '14393.4886' Then '11.01.2022'
        When '14393.4827' Then '05.01.2022'
        When '14393.4825' Then '14.12.2021'
        When '14393.4771' Then '14.11.2021'
        When '14393.4770' Then '09.11.2021'
        When '14393.4704' Then '12.10.2021'
        When '14393.4651' Then '14.09.2021'
        When '14393.4583' Then '10.08.2021'
        When '14393.4532' Then '29.07.2021'
        When '14393.4530' Then '13.07.2021'
        When '14393.4470' Then '07.07.2021'
        When '14393.4467' Then '08.06.2021'
        When '14393.4402' Then '11.05.2021'
        When '14393.4350' Then '13.04.2021'
        When '14393.4288' Then '18.03.2021'
        When '14393.4283' Then '09.03.2021'
        When '14393.4225' Then '09.02.2021'
        When '14393.4169' Then '12.01.2021'
        When '14393.4104' Then '08.12.2020'
        When '14393.4048' Then '19.11.2020'
        When '14393.4046' Then '10.11.2020'
        When '14393.3986' Then '13.10.2020'
        When '14393.3930' Then '08.09.2020'
        When '14393.3866' Then '11.08.2020'
        When '14393.3808' Then '14.07.2020'
        When '14393.3755' Then '18.06.2020'
        When '14393.3750' Then '09.06.2020'
        When '14393.3686' Then '12.05.2020'
        When '14393.3659' Then '21.04.2020'
        When '14393.3630' Then '14.04.2020'
        When '14393.3595' Then '17.03.2020'
        When '14393.3564' Then '10.03.2020'
        When '14393.3542' Then '25.02.2020'
        When '14393.3504' Then '11.02.2020'
        When '14393.3474' Then '23.01.2020'
        When '14393.3443' Then '14.01.2020'
        When '14393.3384' Then '10.12.2019'
        When '14393.3326' Then '12.11.2019'
        When '14393.3300' Then '15.10.2019'
        When '14393.3274' Then '08.10.2019'
        When '14393.3243' Then '03.10.2019'
        When '14393.3242' Then '24.09.2019'
        When '14393.3206' Then '23.09.2019'
        When '14393.3204' Then '10.09.2019'
        When '14393.3181' Then '17.08.2019'
        When '14393.3144' Then '13.08.2019'
        When '14393.3115' Then '16.07.2019'
        When '14393.3085' Then '09.07.2019'
        When '14393.3056' Then '27.06.2019'
        When '14393.3053' Then '18.06.2019'
        When '14393.3025' Then '11.06.2019'
        When '14393.2999' Then '23.05.2019'
        When '14393.2972' Then '19.05.2019'
        When '14393.2969' Then '14.05.2019'
        When '14393.2941' Then '25.04.2019'
        When '14393.2908' Then '25.04.2019'
        When '14393.2906' Then '09.04.2019'
        When '14393.2879' Then '19.03.2019'
        When '14393.2848' Then '12.03.2019'
        When '14393.2828' Then '19.02.2019'
        When '14393.2791' Then '12.02.2019'
        When '14393.2759' Then '17.01.2019'
        When '14393.2724' Then '08.01.2019'
        When '14393.2670' Then '19.12.2018'
        When '14393.2665' Then '11.12.2018'
        When '14393.2641' Then '03.12.2018'
        When '14393.2639' Then '27.11.2018'
        When '14393.2608' Then '13.11.2018'
        When '14393.2580' Then '18.10.2018'
        When '14393.2551' Then '09.10.2018'
        When '14393.2515' Then '20.09.2018'
        When '14393.2485' Then '11.09.2018'
        When '14393.2457' Then '30.08.2018'
        When '14393.2430' Then '14.08.2018'
        When '14393.2396' Then '30.07.2018'
        When '14393.2395' Then '24.07.2018'
        When '14393.2368' Then '16.07.2018'
        When '14393.2363' Then '10.07.2018'
        When '14393.2339' Then '21.06.2018'
        When '14393.2312' Then '12.06.2018'
        When '14393.2273' Then '17.05.2018'
        When '14393.2248' Then '08.05.2018'
        When '14393.2214' Then '17.04.2018'
        When '14393.2189' Then '10.04.2018'
        When '14393.2156' Then '29.03.2018'
        When '14393.2155' Then '22.03.2018'
        When '14393.2125' Then '13.03.2018'
        When '14393.2097' Then '22.02.2018'
        When '14393.2068' Then '13.02.2018'
        When '14393.2035' Then '17.01.2018'
        When '14393.2007' Then '03.01.2018'
        When '14393.1944' Then '12.12.2017'
        When '14393.1914' Then '27.11.2017'
        When '14393.1884' Then '14.11.2017'
        When '14393.1797' Then '02.11.2017'
        When '14393.1794' Then '17.10.2017'
        When '14393.1770' Then '10.10.2017'
        When '14393.1737' Then '28.09.2017'
        When '14393.1715' Then '12.09.2017'
        When '14393.1670' Then '28.08.2017'
        When '14393.1613' Then '16.08.2017'
        When '14393.1593' Then '08.08.2017'
        When '14393.1537' Then '07.08.2017'
        When '14393.1532' Then '18.07.2017'
        When '14393.1480' Then '11.07.2017'
        When '14393.1378' Then '27.06.2017'
        When '14393.1358' Then '13.06.2017'
        When '14393.1198' Then '09.05.2017'
        When '14393.1066' Then '11.04.2017'
        When '14393.969' Then '20.03.2017'
        When '14393.953' Then '14.03.2017'
        When '14393.693' Then '10.01.2017'
        When '14393.576' Then '13.12.2016'
        When '14393.479' Then '09.12.2016'
        When '14393.447' Then '08.11.2016'
        When '14393.351' Then '27.10.2016'
        When '14393.321' Then '11.10.2016'
        When '14393.222' Then '29.09.2016'
        When '14393.187' Then '20.09.2016'
        When '14393.187' Then '13.09.2016'
        When '14393.105' Then '31.08.2016'
        When '14393.82' Then '23.08.2016'
        When '14393.51' Then '09.08.2016'
        When '14393.10' Then '02.08.2016'
        Else tblAssets.oscode + '.' + tblAssets.buildnumber
      End update_date
    From tblAssets
    Where tblAssets.oscode Like '10.0.%s' And tblAssets.buildnumber <>
      '0') As t1
Group By t1.update_date
Order By Total Desc

 

Mister_Nobody
Honored Sweeper II

Chart: Windows 1809 operating systems builds dates

See code of report for Windows 10 in this message:  #M1190

 

 

Mister_Nobody
Honored Sweeper II

Chart: Windows 10 21H2 operating systems builds dates

See code of report for Windows 10 in this message:  #M1190