Windows 11 End of Life Audit

Discover the EOL Status of Your Windows 11 Devices

Microsoft regularly releases new versions of Windows 11, adding new features, improving security, and ensuring that your network is protected. For the Windows 11 Home and Pro editions, each version has a servicing timeline of 24 months. For the Enterprise and Education and IoT Enterprise editions that is 36 months.

To help you keep track of which of your Windows devices are still in support, we have created the Windows 11 end-of-life audit report below. The report will show you which machines are EOL, which ones are nearing their EOL date, and which ones are still supported for some time. You can find more information on our Windows 11 EOL blog.

Run the Windows 11 End-of-Life Audit Now!

Windows 11 End of Life Lansweeper On-Prem Query

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption As OS,
tblAssets.Version,
subquery1.EOLDate,
Case
When IsDate(subquery1.EOLDate) = 1 And GetDate() < subquery1.EOLDate Then
Cast(DateDiff(DAY, GetDate(), subquery1.EOLDate) As NVARCHAR) +
' days remaining'
End As [Days Remaining],
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When subquery1.EOLDate = '' Then ''
When subquery1.EOLDate = 'EOL' Then '#ffadad'
When IsDate(subquery1.EOLDate) = 1 And GetDate() > subquery1.EOLDate Then
'#ffadad'
When IsDate(subquery1.EOLDate) = 1 And GetDate() >= DateAdd(month,
-1, subquery1.EOLDate) Then '#ffd152'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select tblassets.AssetID,
Case
When tblassets.Version = '21H2' And (tblOperatingsystem.Caption Like
'%Home%' Or tblOperatingsystem.Caption Like '%Pro%') Then '2023-10-10'
When tblassets.Version = '21H2' And (tblOperatingsystem.Caption Like
'%Education%' Or
tblOperatingsystem.Caption Like '%Ent__prise%') Then '2024-10-08'
When tblassets.Version = '22H2' And (tblOperatingsystem.Caption Like
'%Home%' Or tblOperatingsystem.Caption Like '%Pro%') Then '2024-10-08'
When tblassets.Version = '22H2' And (tblOperatingsystem.Caption Like
'%Education%' Or
tblOperatingsystem.Caption Like '%Ent__prise%') Then '2025-10-14'
When tblassets.Version = '23H2' And (tblOperatingsystem.Caption Like
'%Home%' Or tblOperatingsystem.Caption Like '%Pro%') Then '2025-11-11'
When tblassets.Version = '23H2' And (tblOperatingsystem.Caption Like
'%Education%' Or
tblOperatingsystem.Caption Like '%Ent__prise%') Then '2026-11-10'
Else ''
End As EOLDate
From tblassets
Inner Join tblOperatingsystem On
tblassets.AssetID = tblOperatingsystem.AssetID) As subquery1
On subquery1.AssetID = tblAssets.AssetID
Where tblOperatingsystem.Caption Like '%Windows 11%' And tblState.Statename =
'Active'

Show

Hide