Get an Overview of Red Hat Enterprise Linux End of Life Status
RHEL's life cycle can be very complex and it is hard to keep track of when specific minor versions will go end of life due to their approach of end of life. Having two separate systems, one for major versions and one for minor versions can cause for confusion when trying to determine how long a specific version will be supported. To help you with this problem the report below provides an overview of the multiple end of life dates a Red Hat Enterprise Linux version can have. You can read more about the end of life for RHEL in the RHEL end of life blog post.
RHEL End of Life Audit Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblLinuxSystem.OSRelease,
subquery2.[Full Support],
subquery2.[Maintenance Support 1],
subquery2.[Maintenance Support Or Maintenance Support 2],
subquery2.[Extended life cycle support (ELS) add-on],
Case
When GetDate() <= subquery2.[Extended life cycle support (ELS) add-on] Then
Cast(DateDiff(DAY, GetDate(), subquery2.[Extended life cycle support (ELS) add-on]) As
nvarchar) + ' days remaining'
End As [Days Remaining Until Last EOL Date],
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When GetDate() >= subquery2.[Full Support] Then '#ffdc7a'
When GetDate() >= subquery2.[Maintenance Support 1] Then '#ffdc7a'
When GetDate() >= subquery2.[Maintenance Support Or Maintenance Support 2] Then '#ffdc7a'
When GetDate() >= subquery2.[Extended life cycle support (ELS) add-on] Then
'#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Left Join (Select tblLinuxSystem.AssetID,
Case
When tblLinuxSystem.OSRelease Like '%5.%' then '2013-01-08'
When tblLinuxSystem.OSRelease Like '%6.%' then '2016-05-10'
When tblLinuxSystem.OSRelease Like '%7.%' then '2019-08-06'
When tblLinuxSystem.OSRelease Like '%8.%' then '2024-05-31'
When tblLinuxSystem.OSRelease Like '%9.%' then '2027-05-31'
End As [Full Support],
Case
When tblLinuxSystem.OSRelease Like '%5.%' then '2014-01-31'
When tblLinuxSystem.OSRelease Like '%6.%' then '2017-05-10'
When tblLinuxSystem.OSRelease Like '%7.%' then '2020-08-06'
End As [Maintenance Support 1],
Case
When tblLinuxSystem.OSRelease Like '%5.%' then '2017-03-31'
When tblLinuxSystem.OSRelease Like '%6.%' then '2020-11-30'
When tblLinuxSystem.OSRelease Like '%7.%' then '2024-06-30'
When tblLinuxSystem.OSRelease Like '%8.%' then '2029-05-31'
When tblLinuxSystem.OSRelease Like '%9.%' then '2032-05-31'
End As [Maintenance Support Or Maintenance Support 2],
Case
When tblLinuxSystem.OSRelease Like '%5.%' then '2020-11-30'
When tblLinuxSystem.OSRelease Like '%6.%' then '2024-06-30'
When tblLinuxSystem.OSRelease Like '%7.%' then '2028-06-30'
When tblLinuxSystem.OSRelease Like '%8.%' then '2032-05-31'
When tblLinuxSystem.OSRelease Like '%9.%' then '2035-05-31'
End As [Extended life cycle support (ELS) add-on]
From tblLinuxSystem
Inner Join tblassets On tblassets.AssetID = tblLinuxSystem.AssetID) As subquery2 On subquery2.AssetID = tblAssets.AssetID
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblLinuxSystem.OSRelease Like '%Red Hat Enterprise%' And
tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName
