Linux Systems that do not have a specific package installed

[Adrian_Mulgrew]

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

[Andy_Sismey]

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