→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎06-05-2015 05:12 PM
Solved! Go to Solution.
‎06-08-2015 01:32 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Lastseen,
Coalesce(tSoftwareESET.softwareName, 'none') As softwareName,
tSoftwareESET.softwareVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.AssetID
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.softwareName Like 'ESET admin agent %') Or
(tblSoftwareUni.softwareName Like 'ESET AV client %')) tSoftwareESET
On tSoftwareESET.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tsysAssetTypes.AssetType = -1
Order By tblAssets.AssetName,
tSoftwareESET.softwareName
‎06-08-2015 01:32 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Lastseen,
Coalesce(tSoftwareESET.softwareName, 'none') As softwareName,
tSoftwareESET.softwareVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.AssetID
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.softwareName Like 'ESET admin agent %') Or
(tblSoftwareUni.softwareName Like 'ESET AV client %')) tSoftwareESET
On tSoftwareESET.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tsysAssetTypes.AssetType = -1
Order By tblAssets.AssetName,
tSoftwareESET.softwareName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now