Left Join (Select tblOperatingsystem.AssetID, When GetDate() >= DateAdd(month, -6, subquery1.) Then '#ffd152' When GetDate() >= '' And tblAssets.Version = '1607' And TblOperatingsystem.Caption Like '%LTSC%') Then 'EOL' (tblOperatingsystem.Caption Like '%LTSB%' Or When GetDate() >= '' And tblAssets.Version = '1507' And When GetDate() >= '' And tblAssets.Version = '21H1' Then 'EOL' When GetDate() >= '' And tblAssets.Version = '20H2' And When GetDate() >= '' And tblAssets.Version = '2009' And When GetDate() >= '' And tblAssets.Version = '2004' And When GetDate() >= '' And tblAssets.Version = '1909' And When GetDate() >= '' And tblAssets.Version = '1809' And TblOperatingsystem.Caption Like '%IoT%') Then 'EOL' TblOperatingsystem.Caption Like '%Education%' Or (tblOperatingsystem.Caption Like '%Ent_prise%' Or When GetDate() = '' And tblAssets.Version = '1803' And TblOperatingsystem.Caption Like '%Pro%') Then 'EOL' (tblOperatingsystem.Caption Like '%Home%' Or TblOperatingsystem.Caption Not Like '%LTSC%') Then 'EOL' Windows 10 End of Life Query Select Top 1000000 tblAssets.AssetID,Ĭoalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
You can find more information on our Windows 10 blog. After you've scanned your environment, the color-coded report will indicate which machines are EOL, which ones are nearing their EOL date (EOL date is within 6 months), and which ones are still supported for some time. Luckily, the report below will be able to help here. Especially if you don't even have a complete inventory to begin with.
Releasing feature updates more frequently does have the benefit of being able to update and add features to Windows 10, improving security, and ensuring that your network is adequately protected.Īs is clear by now, tracking all of this can be a nightmare. Unlike previous Windows versions, the new versions are released more frequently than the service packs Microsoft used to work with. Microsoft regularly releases new versions of Windows 10. Discover the End of Life Status of Your Environment