Notification

Icon
Error

Windows Server 2008/2008 R2 EOL

Posted: Monday, January 21, 2019 3:56:42 PM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,738
0
Like
Since I noticed people were asking about how to get a server EOL report. I adapted the Windows 7 EOL report for servers.

Servers that are nearing their EOL (EOL within 1 year) are marked orange. Assets past their EOL are marked red. All other servers are marked green.
For Windows Server 2008/ 2008R2, the amount of days remaining until EOL is also displayed.

The report will only list assets that meet all of the following criteria:
  • The asset state is set to active.
  • The asset is a Windows Server
Code:
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,
  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%' And tblAssets.SP = 1 Then '#ff8b00'
    When GetDate() > '01/14/2020' And tsysOS.OSname Like '%2008%' Then '#ffadad'
    Else '#d4f4be'
  End As backgroundcolor,
  Case
    When tsysOS.OSname Like '%2008%' Then DateDiff(dd, GetDate(), '01/14/2020')
  End As DaysRemaining
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
KevinA-REJIS
#1KevinA-REJIS Member Posts: 17  
posted: 1/22/2019 7:22:19 PM(UTC)
Originally Posted by: Charles.X Go to Quoted Post
Since I noticed people were asking about how to get a server EOL report. I adapted the Windows 7 EOL report for servers.

Servers that are nearing their EOL (EOL within 1 year) are marked orange. Assets past their EOL are marked red. All other servers are marked green.
For Windows Server 2008/ 2008R2, the amount of days remaining until EOL is also displayed.

The report will only list assets that meet all of the following criteria:
  • The asset state is set to active.
  • The asset is a Windows Server

Thanks Charles!

For some reason, the 2008/2008 R2 servers are showing up as green, not orange.
Esben.D
#2Esben.D Member Administration Original PosterPosts: 1,738  
posted: 1/23/2019 5:40:33 PM(UTC)
Looks like report was still set to mark the assets as orange when they were 1 month away from EOL instead of 1 year. I've fixed it.

Active Discussions

Lansweeper non-active computer report
by  Apaulcolypse   Go to last post Go to first unread
Last post: Yesterday at 5:16:21 PM(UTC)
Lansweeper Report for showing CPUs below or above
by  GBA Craig  
Go to last post Go to first unread
Last post: 7/18/2019 3:38:41 PM(UTC)
Lansweeper Hardware list
by  GBA Craig   Go to last post Go to first unread
Last post: 7/18/2019 3:34:43 PM(UTC)
Lansweeper Top 10 users submitting tickets
by  LGuth  
Go to last post Go to first unread
Last post: 7/17/2019 9:29:44 PM(UTC)
Lansweeper Microsoft Patch Tuesday Report - July 2019
by  Noobmode   Go to last post Go to first unread
Last post: 7/17/2019 8:48:08 PM(UTC)
Lansweeper Custom Scanning - file not existing
by  Bruce Garoutte  
Go to last post Go to first unread
Last post: 7/17/2019 8:19:50 PM(UTC)
Lansweeper MouseJack vulnerability affected devices report
by  Viper   Go to last post Go to first unread
Last post: 7/16/2019 5:19:14 PM(UTC)
Lansweeper TPM support
by  Sander Eerdekens  
Go to last post Go to first unread
Last post: 7/16/2019 1:38:17 PM(UTC)