Windows computers that do not have a specific software installed

[Susan_A]

The report below lists Windows computers that are missing a specific software. Replace YourSoftware with the name of the software as listed in Add/Remove Programs (Programs and Features), e.g. Adobe Reader.

The report will only list assets that meet all of the following criteria:

• The asset is a Windows computer.
  
• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once.
  
• The computer does not have the specified software installed.

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
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
Order By tblAssets.Domain,
  tblAssets.AssetName

[Caesar_xG1]

James_W_ I was looking to do something similar: endpoint has "x" software installed, but missing another "x". My example is VPN desktop clients. We are going to a different vendor so I used the above report and changed the software fields names to what I was looking for. It worked, so my suggestion to you is look in programs & features to see what the sw name is and use that. If that fails, look to see how LS is displaying the sw as and use that instead

[cowartatgzla102]

Exactly what I was looking for. Perfect. Thanks for sharing!