→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
LithiumKid1976
Champion Sweeper
can i list all the machines with adobe reader installed?
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
You can do the following to list the information you are after:
  • Open the built-in report "Software: List of software by computer", under Reports/View All Reports.
  • Filter the Software column, i.e. perform a search for Adobe Reader.

View solution in original post

2 REPLIES 2
RCorbeil
Honored Sweeper II
Very easily. Add tblSoftware and tblSoftwareUni to your report and add a filter for tblSoftwareUni.SoftwareName starts with "Adobe Reader".
SELECT Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 AS icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName
FROM
tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
INNER JOIN tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID
WHERE
tblAssetCustom.State = 1
AND tblSoftwareUni.softwareName LIKE 'Adobe Reader%'
Susan_A
Lansweeper Alumni
You can do the following to list the information you are after:
  • Open the built-in report "Software: List of software by computer", under Reports/View All Reports.
  • Filter the Software column, i.e. perform a search for Adobe Reader.