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,933
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: 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,933  
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 Physical Disk Size
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 5:18:38 PM(UTC)
Lansweeper AD User report
by  GMcCartney  
Go to last post Go to first unread
Last post: Yesterday at 12:07:22 PM(UTC)
Lansweeper PC Build Report Missing Software
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 10:28:40 AM(UTC)
Lansweeper Creat report ALL office (ms officce,libreoffice,openoffice)
by  RC62N  
Go to last post Go to first unread
Last post: 11/15/2019 9:58:33 PM(UTC)
Lansweeper How to Report on Dynamic Asset Groups
by  Rob-CD   Go to last post Go to first unread
Last post: 11/15/2019 11:49:22 AM(UTC)
Lansweeper Custom All Assets Report Help
by  Matt Fuhrman  
Go to last post Go to first unread
Last post: 11/14/2019 3:55:25 PM(UTC)
Report Center Calculate your network's computing power
by  GBInnovation   Go to last post Go to first unread
Last post: 11/13/2019 12:11:18 PM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  JacobH  
Go to last post Go to first unread
Last post: 11/12/2019 5:28:37 PM(UTC)