Find All Windows Server 2008/2008R2 Servers in Your Network
Windows Server 2008 and Windows Server 2008 R2 are both no longer supported along with Windows 7 on 14 January 2020. To ensure that your servers are not a security risk, it is highly recommended to upgrade to a newer version of Windows server by the time that the support for Windows Server 2008/2008R2 ends.
The audit below provides a convenient overview of your Windows servers along with a color-coded indication whether action is required or not. This lets you plan and monitor your progress in migrating your old Windows server installations to newer, supported Windows server operating systems.
Windows Server 2008/2008R2 End of Life 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 Like '%2008%' Then DateDiff(dd, GetDate(), '01/14/2020')
End As DaysRemaining,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When tsysOS.OSname Like '%2003%' Then '#ffadad'
When GetDate() > '01/14/2019' And GetDate() < '01/14/2020' And
tsysOS.OSname Like '%2008%' Then '#ffbe38'
When GetDate() > '01/14/2020' And tsysOS.OSname Like '%2008%' 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 > 1 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
