Find All Windows 7 Computers in Your Network
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