→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Adrian_Mulgrew
Engaged Sweeper
Hi,
I'm trying to list all Linux machines the do Not have a particular application installed.
I found a similar post on the forum but it seems to return many duplicates.
Could someone help please?
Thanks
1 REPLY 1
Andy_Sismey
Champion Sweeper III
Does this work ?

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Assettype
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%YourSoftware%') And
tblAssetCustom.State = 1 And tblAssets.Assettype Like '%Linux%'
Order By tblAssets.Domain,
tblAssets.AssetName