Left Join tsysOS On tsysOS.OScode = tblAssets. Inner Join tblState On tblState.State = tblAssetCustom.State It orchestrates the hardware resources for all your basic computing requirements and includes support for all major hardware. Inner Join tsysIPLocations On tsysIPLocations.LocationID =

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 '' What the trick shares in common with the first Mytel trick is that it doesnt use up users data to give them free net. 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 '' For Red Hat Enterprise Linux 8 (CIS Red Hat Enterprise Linux 8 Benchmark version 1.0.1) CIS has worked with the community since 2009 to publish a benchmark for Red Hat Enterprise Linux. When tblLinuxSystem.OSRelease Like '%7.6%' Then '' A step-by-step checklist to secure Red Hat Enterprise Linux: Download Latest CIS Benchmark. When tblLinuxSystem.OSRelease Like '%7.5%' Then '' When tblLinuxSystem.OSRelease Like '%7.4%' Then '' When tblLinuxSystem.OSRelease Like '%7.3%' Then '' 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

Red hat enterprise linux