Adobe reader

[LithiumKid1976]

can i list all the machines with adobe reader installed?

[RCorbeil]

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 · Accepted solution]

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.