Windows 11 End of Life Audit
Operating System SecurityDiscover 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'