This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- Reports & Analytics
- Chart: Windows 10 1607 1809 21H2 (LTSB/LTSC) and W...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2024 04:42 AM - edited 06-13-2024 07:04 AM
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
Labels:
- Labels:
-
Finished Reports
-
Report Center
7 REPLIES 7
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 11:44 AM
Reports are updated up to July 2024
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2024 07:04 AM
Reports are updated up to June 2024
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2024 12:59 PM
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 😊
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2024 05:11 AM - edited 07-17-2024 11:40 AM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2024 05:03 AM - edited 07-17-2024 11:43 AM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2024 04:44 AM - edited 06-13-2024 07:02 AM
Chart: Windows 1809 operating systems builds dates
See code of report for Windows 10 in this message: #M1190
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2024 04:43 AM - edited 06-13-2024 07:02 AM
Chart: Windows 10 21H2 operating systems builds dates
See code of report for Windows 10 in this message: #M1190
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
- Office 365: Users With License in General Discussions
- Trying or edit a report for Windows drivers error on Query screen. Windows: Installed PNP drivers in General Discussions
- OS: Not latest Build of Windows XXX - error with version numbers in Reports & Analytics
- Lansweeper Community Highlights October 2024 in General Discussions
- No Microsoft CVE in Risk insights in General Discussions
