Windows Server 2008/2008R2 End of Life Audit

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 and 2008R2 EOL

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

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting