Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID Subquery1) As subquery2 On subquery2.AssetID = tblAssets.AssetID Inner Join tblassets On tblassets.AssetID = tblLinuxSystem.AssetID) As When tblLinuxSystem.OSRelease Like '%8.3%' Then '' When tblLinuxSystem.OSRelease Like '%8.0%' Then ''Įnd As , When tblLinuxSystem.OSRelease Like '%7.9%' Then '' When tblLinuxSystem.OSRelease Like '%7.8%' Then '' When tblLinuxSystem.OSRelease Like '%8.4%' Then '' When tblLinuxSystem.OSRelease Like '%8.2%' Then '' When tblLinuxSystem.OSRelease Like '%8.1%' Then '' When tblLinuxSystem.OSRelease Like '%7.7%' Then '' When tblLinuxSystem.OSRelease Like '%7.6%' Then ''
![redhat linux 5 end of life redhat linux 5 end of life](https://www.versio.io/img/product-release-version-end-of-life/Red_Hat-Red_Hat_Enterprise_Linux.jpg)
When tblLinuxSystem.OSRelease Like '%7.5%' Then '' When tblLinuxSystem.OSRelease Like '%7.4%' Then '' When tblLinuxSystem.OSRelease Like '%7.3%' Then ''
![redhat linux 5 end of life redhat linux 5 end of life](https://news-cdn.softpedia.com/images/news2/Red-Hat-Enterprise-Linux-5-11-Beta-Officially-Released-450274-2.jpg)
When tblLinuxSystem.OSRelease Like '%7.2%' Then '' When tblLinuxSystem.OSRelease Like '%7.1%' Then ''
Subquery1.,Ĭast(DateAdd(month, 6, subquery1.) As DATE) As RHEL End of Life Audit Query Select Top 1000000 tblAssets.AssetID,Ĭoalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, You can read more about the end of life for RHEL in the RHEL end of life blog post. To help you with this problem the report below provides an overview of the multiple end of life dates a Red Hat Enterprise Linux version can have. Having two separate systems, one for major versions and one for minor versions can cause for confusion when trying to determine how long a specific version will be supported. RHEL's life cycle can be very complex and it is hard to keep track of when specific minor versions will go end of life due to their approach of end of life. Get an Overview of Red Hat Enterprise Linux End of Life Status