Ubuntu Linux End-of-Life Audit
Operating System SecurityFind 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. Due to its wide usage, it 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.
The report below will give you an overview of all Ubuntu installations in your IT environment, along with their end-of-life date and the days remaining until EOL. That way you have an actionable list of devices that need to be updated.
Ubuntu Linux End-of-Life Lansweeper On-Prem 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.10%' Then '2024-07-01'
When tblLinuxSystem.OSRelease Like '%23.04%' Then '2024-01-25'
When tblLinuxSystem.OSRelease Like '%22%' and
tblLinuxSystem.OSRelease Not Like '%LTS%' Then '2023-07-20'
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'