This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
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 LTSB/LTSC dates of updates
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2024 04:42 AM - edited 03-12-2024 06:21 AM
I have created some chart reports.
Source of data is https://learn.microsoft.com/en-us/windows/release-health/release-information
Chart: Windows 1607 operating systems builds dates
Select Top 1000000 Case SubString(tblAssets.oscode, 6, 5) + '.' +
tblAssets.buildnumber
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,
Count(tblAssets.AssetID) As Total
From tblAssets
Where tblAssets.oscode Like '10.0.14393' And tblAssets.buildnumber <> '0'
Group By tblAssets.oscode,
tblAssets.buildnumber
Order By Total Desc
Labels:
- Labels:
-
Finished Reports
-
Report Center
5 REPLIES 5
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
Chart: Windows 10 1607 1809 21H2 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 '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.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.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 03-12-2024 06:21 AM
Bonus 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.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.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.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 03-12-2024 06:22 AM
Chart: Windows 1809 operating systems builds dates
Select Top 1000000 Case SubString(tblAssets.oscode, 6, 5) + '.' +
tblAssets.buildnumber
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'
Else tblAssets.oscode + '.' + tblAssets.buildnumber
End update_date,
Count(tblAssets.AssetID) As Total
From tblAssets
Where tblAssets.oscode Like '10.0.17763' And tblAssets.buildnumber <> '0'
Group By tblAssets.oscode,
tblAssets.buildnumber
Order By Total Desc
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2024 04:43 AM - edited 03-12-2024 06:22 AM
Chart: Windows 10 21H2 operating systems builds dates
Select Top 1000000 Case SubString(tblAssets.oscode, 6, 5) + '.' +
tblAssets.buildnumber
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'
Else tblAssets.oscode + '.' + tblAssets.buildnumber
End update_date,
Count(tblAssets.AssetID) As Total
From tblAssets
Where tblAssets.oscode Like '10.0.19044' And tblAssets.buildnumber <> '0'
Group By tblAssets.oscode,
tblAssets.buildnumber
Order By Total Desc
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
- BIOS Version Audit report for Microsoft Windows, Linux , VMware ESXi in Reports & Analytics
- Dell Warranty Info in General Discussions
- Lansweeper poor scanning performance using Windows Server 2022 in General Discussions
- Report combining Windows computers where OS is known or not in Reports & Analytics
- Windows 11 24H2 CPU Requirement Report in Reports & Analytics
