‎12-04-2014 11:55 AM
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
‎08-02-2022 06:44 PM
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
‎04-14-2016 12:41 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now