→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎01-12-2016 09:06 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Username,
tblADusers.Displayname,
tblADusers.Title,
tblADusers.Department,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblRegistry.Regkey,
tblRegistry.Value
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Right Outer Join tblADusers On tblADusers.Username = tblAssets.Username
Left Outer Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where
tblRegistry.Regkey = 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer' And tblRegistry.Value Like '%8.0%'
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 tblAssetCustom.State = 1 And tblSoftwareUni.softwareName =
'Proxy Pro Host'
Solved! Go to Solution.
‎01-12-2016 11:28 PM
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Username,
tblADusers.Displayname,
tblADusers.Title,
tblADusers.Department,
tblAssets.Lastseen,
tblAssets.Lasttried
FROM
tblAssets
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
INNER JOIN tblSoftware ON tblSoftware.AssetID = tblAssets.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.SoftID
LEFT JOIN tblADusers ON tblADusers.Username = tblAssets.Username
WHERE
tblSoftwareUni.softwareName LIKE '%Internet Explorer%'
AND tblSoftwareUni.softwareName LIKE '% 8'
AND tblSoftwareUni.softwareName NOT LIKE 'Security Update%'
AND tblSoftwareUni.SoftwarePublisher LIKE 'Microsoft Corp%'
AND tblAssets.AssetID NOT IN ( SELECT
tblAssets.AssetID
FROM
tblAssets
INNER JOIN tblSoftware ON tblSoftware.AssetID = tblAssets.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.SoftID
WHERE
tblSoftwareUni.SoftwareName = 'Proxy Pro Host'
)
‎01-13-2016 11:27 PM
‎01-12-2016 11:28 PM
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Username,
tblADusers.Displayname,
tblADusers.Title,
tblADusers.Department,
tblAssets.Lastseen,
tblAssets.Lasttried
FROM
tblAssets
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
INNER JOIN tblSoftware ON tblSoftware.AssetID = tblAssets.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.SoftID
LEFT JOIN tblADusers ON tblADusers.Username = tblAssets.Username
WHERE
tblSoftwareUni.softwareName LIKE '%Internet Explorer%'
AND tblSoftwareUni.softwareName LIKE '% 8'
AND tblSoftwareUni.softwareName NOT LIKE 'Security Update%'
AND tblSoftwareUni.SoftwarePublisher LIKE 'Microsoft Corp%'
AND tblAssets.AssetID NOT IN ( SELECT
tblAssets.AssetID
FROM
tblAssets
INNER JOIN tblSoftware ON tblSoftware.AssetID = tblAssets.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.SoftID
WHERE
tblSoftwareUni.SoftwareName = 'Proxy Pro Host'
)
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now