‎12-10-2014 03:01 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where ((tblSoftwareUni.softwareName Like 'Adobe Flash%' And
tblSoftware.softwareVersion <= '15.0.0.167' And
tblSoftware.softwareVersion >= '15.0.0.0') Or
(tblSoftwareUni.softwareName Like 'Adobe Flash%' And
tblSoftware.softwareVersion <= '13.0.0.244' And
tblSoftware.softwareVersion >= '13.0.0.0') Or
(tblSoftwareUni.softwareName Like 'Adobe Flash%' And
tblSoftware.softwareVersion <= '11.2.202.406' And
tblSoftware.softwareVersion >= '11.0.0.0') Or
(tblSoftwareUni.softwareName Like 'Adobe AIR%' And
tblSoftware.softwareVersion <= '15.0.0.249' And
tblSoftware.softwareVersion >= '15.0.0.0')) And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion Desc
‎03-06-2015 08:02 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where ((tblSoftwareUni.softwareName Like 'Adobe Flash%' And
tblSoftware.softwareVersion < '16.0.0.305' And
tblSoftware.softwareVersion >= '14.0.0.0') Or
(tblSoftwareUni.softwareName Like 'Adobe Flash%' And
tblSoftware.softwareVersion < '13.0.0.269' And
tblSoftware.softwareVersion >= '13.0.0.0') Or
(tblSoftwareUni.softwareName Like 'Adobe Flash%' And
tblSoftware.softwareVersion <= '11.2.202.406' And
tblSoftware.softwareVersion >= '11.0.0.0') Or
(tblSoftwareUni.softwareName Like 'Adobe Acrobat XI%' And
tblSoftware.softwareVersion <= '11.0.08' And
tblSoftware.softwareVersion >= '11.0.00') Or
(tblSoftwareUni.softwareName Like 'Adobe Acrobat X%' And
tblSoftware.softwareVersion <= '10.1.12' And
tblSoftware.softwareVersion >= '10.0.0') Or (tblSoftwareUni.softwareName
Like 'Java 7%' And tblSoftware.softwareVersion < '7.0.760' And
tblSoftware.softwareVersion >= '7.0.0') Or (tblSoftwareUni.softwareName
Like 'Java 6%' And tblSoftware.softwareVersion < '6.0.45' And
tblSoftware.softwareVersion >= '6.0.0') Or (tblSoftwareUni.softwareName
Like 'Java 8%' And tblSoftware.softwareVersion <= '8.0.250' And
tblSoftware.softwareVersion >= '8.0.0') Or (tblSoftwareUni.softwareName
Like 'Java SE%' And tblSoftware.softwareVersion < '1.8' And
tblSoftware.softwareVersion >= '1.7.0') Or (tblSoftwareUni.softwareName
Like 'Adobe Acrobat 9%' And tblSoftware.softwareVersion <= '9.0.0') Or
(tblSoftwareUni.softwareName Like 'Adobe AIR%' And
tblSoftware.softwareVersion <= '15.0.0.249' And
tblSoftware.softwareVersion >= '15.0.0.0')) And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblSoftwareUni.softwareName Desc,
tblSoftware.softwareVersion Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now