Query Details
Device Countdown Endof Life21h1
Query
// Show the number of windows devices on 21H1, the date of EOL for 21H1 as well as a countdown in days.
IntuneDevices
| where OS has "Windows"
| extend Build = split(OSVersion, ".")[2]
| where Build contains "19043"
| where SkuFamily == "Enterprise"
| summarize count(DeviceName) by tostring(Build)
| extend ['21H1 Enterprise - End of servicing'] = todatetime('2022-12-13')
| extend ['Countdown in Days'] = datetime_diff('day', now(), ['21H1 Enterprise - End of servicing'])
Explanation
This query is used to find the number of Windows devices running the 21H1 build (specifically build number 19043) in an enterprise environment. It also provides the end of life (EOL) servicing date for the 21H1 build, which is December 13, 2022. Additionally, it calculates the number of days remaining until this EOL date from the current date.
Details
Ugur Koc
Released: August 11, 2022
Tables
IntuneDevices
Keywords
IntuneDevices,OS,Windows,Build,OSVersion,SkuFamily,Enterprise,DeviceName,EndofServicing,CountdowninDays
Operators
whereextendsplitcontainssummarizetodatetimedatetime_diffnowtostringcount