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: 25  
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 local admin users of a specific device
by  kdunnett   Go to last post Go to first unread
Last post: 5/25/2020 9:30:26 PM(UTC)
Lansweeper How to get total disk usage of all VM assets
by  Erik.T  
Go to last post Go to first unread
Last post: 5/25/2020 4:49:58 PM(UTC)
Lansweeper Windows Server 2016 & Patch Tuesday May 2020
by  Hendrik.VE   Go to last post Go to first unread
Last post: 5/22/2020 8:20:05 PM(UTC)
Lansweeper Users mapped "shared" printers
by  Andy.S  
Go to last post Go to first unread
Last post: 5/22/2020 4:16:23 PM(UTC)
Lansweeper Report on Assets in a Static Group
by  Andy.S   Go to last post Go to first unread
Last post: 5/22/2020 2:55:03 PM(UTC)
Lansweeper Windows 10 Activation
by  TruSynergy  
Go to last post Go to first unread
Last post: 5/21/2020 7:54:25 PM(UTC)
Lansweeper Filtering Report Based On Active Status
by  CyberCitizen   Go to last post Go to first unread
Last post: 5/21/2020 4:04:33 AM(UTC)
Lansweeper Windows: Unauthorized Administrators (Built-in)
by  Jackie.L  
Go to last post Go to first unread
Last post: 5/20/2020 8:01:17 PM(UTC)