‎05-29-2020 06:01 PM
‎11-04-2021 07:47 PM
‎11-05-2021 12:07 AM
RC62N wrote:
You're reviving an old exchange where the solution presumably worked since there was no followup. If it's not working for you, consider sharing your code to see if anyone can spot a flaw in the selection logic.
‎11-03-2021 08:55 PM
‎06-03-2020 04:25 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
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 tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like 'Trend%' And
tblAssets.AssetName Not Like '%PC12%' And tblAssets.AssetName Not Like
'%PC34%' And tblAssets.AssetName Not Like '%PC56%') And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now