CentOS EOL Audit

Find Unsupported CentOS Installations

Originally released in 2004, the CentOS Project is a free open-source operating system derived from the sources of Red Hat Enterprise Linux. It aims to provide open-source communities with a rich base to build upon.

CentOS Linux is a consistent and predictable platform, that provides communities with a solid and predictable base. Its last supported version, CentOS Linux 7, will be going end of life on the 30th of June, 2024. As this is the last supported version, this means CentOS Linux will then be fully end of life. Users who are still running this operating system will need to migrate. You can read more details in our CentOS Linux end-of-life blog.

CentOS Stream, is the upstream project, that tracks just ahead of RHEL. It allows users to contribute directly to the official repository and includes any upcoming minor updates before they are added to RHEL. This makes CentOS Stream a reliable platform for innovation.

The report below will give you an overview of all CentOS installations in your network. This way you have an actionable list of devices that still need to be upgraded or migrated.

Run the CentOS Linux EOL Audit Now!

CentOS EOL Lansweeper Classic Query

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
subquery1.OSRelease,
subquery1.EOLDate,
Case
When IsDate(subquery1.EOLDate) = 1 Then
Cast(DateDiff(DAY, GetDate(), subquery1.EOLDate) As NVARCHAR) +
' days remaining'
End As [Days Remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When GetDate() > subquery1.EOLDate Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
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
Inner Join tblLinuxSystem On tblLinuxSystem.AssetID = tblAssets.AssetID
Left Join (Select tblLinuxSystem.OSRelease,
Case
When tblLinuxSystem.OSRelease not like '%stream%' and tblLinuxSystem.OSRelease Like '%3%' Then '2010-10-31'
When tblLinuxSystem.OSRelease not like '%stream%' and tblLinuxSystem.OSRelease Like '%4%' Then '2012-02-29'
When tblLinuxSystem.OSRelease not like '%stream%' and tblLinuxSystem.OSRelease Like '%5%' Then '2017-03-31'
When tblLinuxSystem.OSRelease not like '%stream%' and tblLinuxSystem.OSRelease Like '%6%' Then '2020-11-30'
When tblLinuxSystem.OSRelease not like '%stream%' and tblLinuxSystem.OSRelease Like '%7%' Then '2024-06-30'
When tblLinuxSystem.OSRelease not like '%stream%' and tblLinuxSystem.OSRelease Like '%8%' Then '2021-12-31'
When tblLinuxSystem.OSRelease like '%stream%' and tblLinuxSystem.OSRelease Like '%8%' Then '2024-05-31'
When tblLinuxSystem.OSRelease like '%stream%' and tblLinuxSystem.OSRelease Like '%9%' Then '2027-05-31'
Else 'EOL'
End As EOLDate,
tblLinuxSystem.AssetID
From tblLinuxSystem
Where tblLinuxSystem.OSRelease Like '%CentOS%') As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where tblLinuxSystem.OSRelease Like '%CentOS%'
And tblState.Statename = 'Active'

Show

Hide