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,982
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%' 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: 29  
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,982  
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 Software deployment initiated by user
by  LS_enthusiast_4444  
Go to last post Go to first unread
Last post: Yesterday at 9:28:18 PM(UTC)
Lansweeper Help Desk not disabling for regular users?
by  FrankSc   Go to last post Go to first unread
Last post: Yesterday at 8:18:38 PM(UTC)
Lansweeper Satisfaction Questionnaire after ticket close
by  mouaad  
Go to last post Go to first unread
Last post: Yesterday at 4:31:44 PM(UTC)
Lansweeper Microsoft EDGE browser support
by  Vapoured   Go to last post Go to first unread
Last post: Yesterday at 4:54:30 AM(UTC)
Lansweeper Asset Management - Unattached assets
by  MrDiamond  
Go to last post Go to first unread
Last post: 11/25/2020 8:15:16 PM(UTC)
Lansweeper Lansweeper Fresh Install Hanging, High CPU, Unusable
by  ebars   Go to last post Go to first unread
Last post: 11/24/2020 7:53:38 PM(UTC)
Lansweeper Forwarding tickets to regular email recipents
by  ChristerT  
Go to last post Go to first unread
Last post: 11/24/2020 9:48:15 AM(UTC)