Ubuntu Linux EOL

Find Unsupported Ubuntu Installations

Initially released in 2004, Ubuntu is a Linux distribution primarily based on Debian and has a desktop, server, core, IoT, and robot edition. Aside from regular releases, the majority of users use an LTS version of Ubuntu. The main benefits of Ubuntu are that it has its own software repositories, and due to its wide usage is one of the most supported Linux operating systems out there. Read more about the Ubuntu Linux lifecycle in our Ubuntu Linux EOL blog post.

Ubuntu Linux EOL Query

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
Coalesce(tblAssets.Username, s2.username) As [Last User],
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
subquery1.OSRelease,
subquery1.EOLDate,
Case
When IsDate(subquery1.EOLDate) = 1 And GetDate() < subquery1.EOLDate Then
Cast(DateDiff(DAY, GetDate(), subquery1.EOLDate) As NVARCHAR) +
' days remaining'
End As [Days Remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When subquery1.EOLDate = 'EOL' Then '#ffadad'
When IsDate(subquery1.EOLDate) = 1 And GetDate() > subquery1.EOLDate Then
'#ffadad'
When IsDate(subquery1.EOLDate) = 1 And GetDate() >= DateAdd(month,
-1, subquery1.EOLDate) Then '#ffd152'
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 (Select tblLinuxUser.username,
tblLinuxUserLogon.LogonTime,
tblLinuxUser.assetid
From tblLinuxUser
Inner Join tblLinuxUserLogon On tblLinuxUserLogon.Id = tblLinuxUser.id
Inner Join (Select tblLinuxUser.assetid,
Max(tblLinuxUserLogon.LogonTime) As maxLogonTime
From tblLinuxUser
Inner Join tblLinuxUserLogon On tblLinuxUserLogon.Id = tblLinuxUser.id
Group By tblLinuxUser.assetid) s1 On s1.maxLogonTime =
tblLinuxUserLogon.LogonTime) s2 On s2.AssetId = tblAssets.AssetID
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 Like '%24%' Then 'N/A'
When tblLinuxSystem.OSRelease Like '%23%' Then 'N/A'
When tblLinuxSystem.OSRelease Like '%14%LTS%' Then '2024-04-01'
When tblLinuxSystem.OSRelease Like '%16%LTS%' Then '2026-04-01'
When tblLinuxSystem.OSRelease Like '%18%LTS%' Then '2028-04-01'
When tblLinuxSystem.OSRelease Like '%20%LTS%' Then '2030-04-01'
When tblLinuxSystem.OSRelease Like '%22%LTS%' Then '2032-04-01'
When tblLinuxSystem.OSRelease Like '%21%' Then '2022-07-14'
When tblLinuxSystem.OSRelease Like '%20%' Then '2021-07-22'
When tblLinuxSystem.OSRelease Like '%19.1%' Then '2020-07-17'
When tblLinuxSystem.OSRelease Like '%19.0%' Then '2020-01-23'
When tblLinuxSystem.OSRelease Like '%18%' Then '2019-07-18'
When tblLinuxSystem.OSRelease Like '%17.1%' Then '2018-07-19'
When tblLinuxSystem.OSRelease Like '%17.0%' Then '2018-01-13'
When tblLinuxSystem.OSRelease Like '%16%' Then '2017-07-20'
When tblLinuxSystem.OSRelease Like '%15.1%' Then '2016-07-28'
When tblLinuxSystem.OSRelease Like '%15.0%' Then '2016-02-04'
When tblLinuxSystem.OSRelease Like '%14%' Then '2015-07-23'
When Cast(SubString(tblLinuxSystem.OSRelease, PatIndex('%[0-9]%',
tblLinuxSystem.OSRelease), 2) As int) < 14 Then 'EOL'
Else 'EOL'
End As EOLDate,
tblLinuxSystem.AssetID
From tblLinuxSystem
Where tblLinuxSystem.OSRelease Like '%ubuntu_[0-9]%') As subquery1
On subquery1.AssetID = tblAssets.AssetID
Where tblLinuxSystem.OSRelease Like '%ubuntu_[0-9]%' And tblState.Statename =
'Active'

Audit and Take Action in 3 Easy Steps

1. Download & Install Lansweeper

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting