Debian is a free, open-source operating system built on the Linux kernel and maintained by a global volunteer community. It’s known for its stability and long support cycles, which makes it a common choice for servers, desktops, cloud deployments, and enterprise environments.
This report will help you find every Debian installation in your network as well as the version each one is running, along with its end of life date and how much time remains before support ends. This way, you can spot outdated or soon to be unsupported installations ahead of time, so you can plan upgrades. For more information on the Debian lifecycle, check out our End of Life blog.
To the Lansweeper Sites OS Lifecycle page ->
EU environment · US environment
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.MajorVersion As [Debian Version],
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 tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblLinuxSystem On tblLinuxSystem.AssetID = tblAssets.AssetID
Left Join (Select base.OSRelease,
base.AssetID,
base.MajorVersion,
Case base.MajorVersion
When '15' Then 'TBA' -- duke
When '14' Then 'TBA' -- forky
When '13' Then '2030-06-30' -- trixie
When '12' Then '2028-06-30' -- bookworm
When '11' Then '2026-08-31' -- bullseye
When '10' Then '2024-06-30' -- buster
When '9' Then '2022-07-01' -- stretch
When '8' Then '2020-06-30' -- jessie
When '7' Then '2018-05-31' -- wheezy
When '6' Then '2016-02-29' -- squeeze
Else 'EOL'
End As EOLDate
From (Select tblLinuxSystem.OSRelease,
tblLinuxSystem.AssetID,
Substring(tblLinuxSystem.OSRelease,
PatIndex('%[0-9]%', tblLinuxSystem.OSRelease),
PatIndex('%[^0-9]%',
Substring(tblLinuxSystem.OSRelease,
PatIndex('%[0-9]%', tblLinuxSystem.OSRelease), 100) + 'X') - 1)
As MajorVersion
From tblLinuxSystem
Where tblLinuxSystem.OSRelease Like '%Debian%') As base) As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where tblLinuxSystem.OSRelease Like '%Debian%' And tblState.Statename = 'Active'
Explore the full platform, free for 14 days.
No credit card required.