Microsoft brings out new feature updates every few months to add additional features and improvements. Security fixes are also released monthly to patch vulnerabilities. However, Windows version are not supported forever. Windows 7 will no longer be supported on 14 January 2020 (run our Windows 7 EOL audit). Running an unsupported version of Windows is a significant security risk as these operating systems are no longer updated with new security patches. Therefore, it is important that the migration to a supported Windows version is completed before January 2020.
The Windows 7 EOL audit below can help in discovering which machines in your network are running unsupported Windows versions and which ones have been updated already. This way you can track your Windows 10 migration process easily.
Windows 7 EOL Query
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblOperatingsystem.Caption As [Operating System],
tblAssets.SP As SP,
Case
When tsysOS.OSname = 'Win 7' And tblAssets.SP = 1 Then DateDiff(dd,
GetDate(), '01/14/2020')
End As DaysRemaining,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When tsysOS.OSname = 'Win XP' Then '#ffadad'
When tsysOS.OSname = 'Win 7' And tblAssets.SP <> 1 Then '#ffdb8e'
When tsysOS.OSname = 'Win 7' And tblAssets.SP = 1 Then '#ffbe38'
When GetDate() > '01/14/2019' And GetDate() < '01/14/2020' And
tsysOS.OSname = 'Win 7' And tblAssets.SP = 1 Then '#ff8b00'
When GetDate() > '01/14/2020' And tsysOS.OSname = 'Win 7' And
tblAssets.SP = 1 Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
