→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Susan_A
Lansweeper Alumni
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
11 REPLIES 11

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
Engaged Sweeper
Exactly what I was looking for. Perfect. Thanks for sharing!