OpenSSL 3 Vulnerability Audit

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
Coalesce(tblAssets.Username, s2.username) As [Last User],
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblLinuxSystem.OSRelease,
tblAssets.Lastseen,
tblAssets.Lasttried
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 (Select tblLinuxUser.username,
tblLinuxUserLogon.LogonTime,
tblLinuxUser.assetid
From tblLinuxUser
Inner Join tblLinuxUserLogon On tblLinuxUserLogon.Id = tblLinuxUser.id
Inner Join (Select tblLinuxUser.assetid,
Max(tblLinuxUserLogon.LogonTime) As maxLogonTime
From tblLinuxUser
Inner Join tblLinuxUserLogon On tblLinuxUserLogon.Id = tblLinuxUser.id
Group By tblLinuxUser.assetid) s1 On s1.maxLogonTime =
tblLinuxUserLogon.LogonTime) s2 On s2.AssetId = tblAssets.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblLinuxSystem On tblLinuxSystem.AssetID = tblAssets.AssetID
Where (tblLinuxSystem.OSRelease Like '%Alma%9.%' or tblLinuxSystem.OSRelease Like '%Alpine%Edge%' or tblLinuxSystem.OSRelease Like '%Alpine%3.15%'
or tblLinuxSystem.OSRelease Like '%Alpine%3.16%' or tblLinuxSystem.OSRelease Like '%Amazon%2022%' or tblLinuxSystem.OSRelease Like '%Ubuntu%22.04%LTS%'
or tblLinuxSystem.OSRelease Like '%Ubuntu%22.10%' or tblLinuxSystem.OSRelease Like '%CentOS%9%' or tblLinuxSystem.OSRelease Like '%Debian%12%'
or tblLinuxSystem.OSRelease Like '%Euro%Linux%9%' or tblLinuxSystem.OSRelease Like '%Euro%Linux%9%' or tblLinuxSystem.OSRelease Like '%Fedora%36%'
or tblLinuxSystem.OSRelease Like '%Fedora%37%' or tblLinuxSystem.OSRelease Like '%Gentoo%' or tblLinuxSystem.OSRelease Like '%Mint%21%'
or tblLinuxSystem.OSRelease Like '%Kali%2022.3%' or tblLinuxSystem.OSRelease Like '%OpenMandriva%4.2%' or tblLinuxSystem.OSRelease Like '%OpenMandriva%4.3%'
or tblLinuxSystem.OSRelease Like '%openSUSE%Tumbleweed%' or tblLinuxSystem.OSRelease Like '%Oracle%8.%' or tblLinuxSystem.OSRelease Like '%Oracle%9.%'
or tblLinuxSystem.OSRelease Like '%Red Hat%9.%' or tblLinuxSystem.OSRelease Like '%SUSE%Enterprise%15%')
And tblState.Statename = 'Active'