Fedora Linux EOL

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-12-05'
When tblLinuxSystem.OSRelease Like '%38%' Then '2024-05-21'
When tblLinuxSystem.OSRelease Like '%39%' Then '2024-11-26'
When tblLinuxSystem.OSRelease Like '%40%' Then '2025-05-13'
When tblLinuxSystem.OSRelease Like '%41%' Then '2025-11-19'
When tblLinuxSystem.OSRelease Like '%42%' Then '2026-05-13'
When tblLinuxSystem.OSRelease Like '%43%' Then '2026-12-09'
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'