Microsoft brings out new feature updates every few months to add additional features and improvements. Every Windows 10 version gets their own specific patches on Patch Tuesday, however, much like Windows 7, Windows 10 builds have a limited life span. Since the lifespan of Windows 10 version 1703 is close to its end, which means no more updates. We have an updated blog regarding the upcoming Windows 10 EOL versions.
The audit below provides you a list of all Windows 10, 1703 machines along with how long you have until the end of life date is hit. Since this date is set for October 9, 2019, you don’t have long to update your Windows 10 versions.
Windows 10 Version 1703 EOL Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblOperatingsystem.Caption As OS,
tblAssets.Version,
Case
When tblAssets.Version < '1703' Then 'EOL'
When tblAssets.Version = '1703' And (tblOperatingsystem.Caption Like
'%Home%' Or tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
When tblAssets.Version = '1703' And (tblOperatingsystem.Caption Like
'%Enterprise%' Or
tblOperatingsystem.Caption Like '%Education%') Then 'EOL in ' + EOL.Days +
' days'
When EOL.Days Is Null Then 'Rescan asset'
End As Status,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When EOL.Days > 0 And EOL.Days <= 90 Then '#ffd152'
When EOL.Days <= 0 Then '#ffadad'
Else '#ffadad'
End As backgroundcolor
From tblAssets
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
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select Top 1000000 tblAssets.AssetID,
Case
When tblAssets.Version < '1703' Then '-1'
When tblAssets.Version = '1703' And (tblOperatingsystem.Caption Like
'%Enterprise%' Or
tblOperatingsystem.Caption Like '%Education%') Then
Cast(DateDiff(DAY, GetDate(), '2019-10-08') As nvarchar)
When tblAssets.Version = '1703' And (tblOperatingsystem.Caption Like
'%Home%' Or
tblOperatingsystem.Caption Like '%Pro%') Then Cast(DateDiff(DAY,
GetDate(), '2018-10-09') As nvarchar)
End As Days
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType =
tblAssets.Assettype
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblState.Statename = 'Active' And tsysOS.OSname = 'Win 10'
And tblAssets.Version <= '1703') As EOL On
EOL.AssetID = tblAssets.AssetID
Where tblAssets.Version <= '1703' And tblState.Statename = 'Active' And
tsysOS.OSname = 'Win 10'
Order By tblAssets.Domain,
tblAssets.AssetName
