→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎01-28-2015 04:54 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblLinuxSystem.OSRelease,
tblAssets.IPAddress,
'Urgent' As Priority,
'https://bugzilla.redhat.com/show_bug.cgi?id=1183461' As hyperlink_hyp,
'CVE Link' As hyperlink_name_hyp,
tblSoftwareUni.softwareName,
tblLinuxSoftware.Version,
tblLinuxSoftware.Release,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where tblLinuxSystem.OSRelease Not Like '%SUSE%' And
(tblSoftwareUni.softwareName Like 'glibc%' Or tblSoftwareUni.softwareName =
'nscd') And (tblLinuxSoftware.Version Like '2.[2-9]%' Or
tblLinuxSoftware.Version Like '2.1[0-7]') And tblLinuxSoftware.Version <>
'2.20' And tblAssetCustom.State = 1
Order By tblLinuxSoftware.Version Desc,
tblLinuxSoftware.Release Desc,
tblAssets.AssetName,
tblSoftwareUni.softwareName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now