Fedora Linux is a Linux distribution created and managed by the Fedora Project. As insinuated by the name, Fedora is primarily sponsored by Red Hat. It is also the upstream source for Red Hat Enterprise Linux. Fedora currently has 5 different editions, Workstation, Server, CoreOS, Silverblue, and IoT. Fedora releases a new version every 6 months with older versions going end-of-life. You can read more about the Fedora Linux lifecycle in our Fedora Linux EOL blog post.
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 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 tblLinuxSystem.OSRelease,
Case
When tblLinuxSystem.OSRelease Like '%20%' Then '2015-06-23'
When tblLinuxSystem.OSRelease Like '%21%' Then '2015-12-01'
When tblLinuxSystem.OSRelease Like '%22%' Then '2016-07-19'
When tblLinuxSystem.OSRelease Like '%23%' Then '2016-12-20'
When tblLinuxSystem.OSRelease Like '%24%' Then '2017-08-08'
When tblLinuxSystem.OSRelease Like '%25%' Then '2017-12-12'
When tblLinuxSystem.OSRelease Like '%26%' Then '2018-05-29'
When tblLinuxSystem.OSRelease Like '%27%' Then '2018-11-30'
When tblLinuxSystem.OSRelease Like '%28%' Then '2019-05-28'
When tblLinuxSystem.OSRelease Like '%29%' Then '2019-11-26'
When tblLinuxSystem.OSRelease Like '%30%' Then '2020-05-26'
When tblLinuxSystem.OSRelease Like '%31%' Then '2020-11-24'
When tblLinuxSystem.OSRelease Like '%32%' Then '2021-05-25'
When tblLinuxSystem.OSRelease Like '%33%' Then '2021-11-30'
When tblLinuxSystem.OSRelease Like '%34%' Then '2022-06-07'
When tblLinuxSystem.OSRelease Like '%35%' Then '2022-12-13'
When tblLinuxSystem.OSRelease Like '%36%' Then '2023-05-16'
When tblLinuxSystem.OSRelease Like '%37%' Then '2023-11-14'
When tblLinuxSystem.OSRelease Like '%38%' Then '2024-05-14'
When tblLinuxSystem.OSRelease Like '%39%' Then '2024-11-12'
When tblLinuxSystem.OSRelease Like '%40%' Then '2025-05-13'
Else 'EOL'
End As EOLDate,
tblLinuxSystem.AssetID
From tblLinuxSystem
Where tblLinuxSystem.OSRelease Like '%Fedora%') As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where tblLinuxSystem.OSRelease Like '%Fedora%' And tblState.Statename = 'Active'
