Notification

Icon
Error

Linux Systems that do not have a specific package installed

Posted: Tuesday, November 10, 2020 4:50:54 PM(UTC)
raidan

raidan

Member Original PosterPosts: 1
0
Like
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.S
#1Andy.S Member Posts: 68  
posted: 12/3/2020 3:47:29 PM(UTC)
Does this work ?

Code:
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

Active Discussions

Lansweeper Modifying Purchase Date / Yearly Refresh Report
by  Cripple.Zero   Go to last post Go to first unread
Last post: Yesterday at 7:06:47 PM(UTC)
Lansweeper Report showing only Wi-Fi Devices and MAC addresses
by  ethanthekiwi   Go to last post Go to first unread
Last post: 5/6/2021 9:18:07 PM(UTC)
Lansweeper Tweak LanSweepers Bios Version Audit to show Last Seen
by  Tyler M.  
Go to last post Go to first unread
Last post: 5/6/2021 8:22:40 PM(UTC)
Lansweeper Patch Volume Across Fleet
by  darren.kimber  
Go to last post Go to first unread
Last post: 5/5/2021 11:29:33 PM(UTC)
Lansweeper Show Date Without Time
by  nhouse24   Go to last post Go to first unread
Last post: 5/4/2021 10:39:43 PM(UTC)
Lansweeper Report of list of assets
by  Carlos Montes  
Go to last post Go to first unread
Last post: 5/4/2021 2:52:15 PM(UTC)