‎05-23-2018 10:15 PM
Solved! Go to Solution.
‎05-28-2018 04:58 PM
tblSoftwareUni.softwareName Not Like 'EMS for Outlook'Will return all software which does not match that string. This means that it will pretty much return all software you have on the asset.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%EMS for Outlook%') And
tblSoftwareUni.softwareName Like 'Microsoft Office 365%' And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
‎05-28-2018 04:58 PM
tblSoftwareUni.softwareName Not Like 'EMS for Outlook'Will return all software which does not match that string. This means that it will pretty much return all software you have on the asset.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%EMS for Outlook%') And
tblSoftwareUni.softwareName Like 'Microsoft Office 365%' And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
‎05-28-2018 07:34 PM
‎10-18-2019 02:14 AM
TylerO wrote:
Thanks Charles.X! That makes perfect sense about it returning all software. This solution works perfectly.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now