→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎01-28-2015 04:48 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblLinuxSystem.OSRelease,
tblAssets.IPAddress,
'Urgent' As Priority,
'http://support.novell.com/security/cve/CVE-2015-0235.html' 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 Like '%SUSE%11%' And
(tblSoftwareUni.softwareName Like 'glibc%' Or tblSoftwareUni.softwareName =
'nscd') And (tblLinuxSoftware.Version = '2.11.3' And
tblLinuxSoftware.Release < '17.45.55.5' Or tblLinuxSoftware.Version <
'2.11.3')) Or
(tblLinuxSystem.OSRelease Like '%SUSE%10%' And (tblSoftwareUni.softwareName
Like 'glibc%' Or tblSoftwareUni.softwareName = 'nscd') And
(tblLinuxSoftware.Version = '2.4' And tblLinuxSoftware.Release < '31.113.3' Or
tblLinuxSoftware.Version < '2.4') 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