/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Run a report of computers that have acrobat installed.

09/07/2016 1607 views

Need to run a report that has all the attributes.

Computer name with Acrobat installed?   Example:   Standard or PRO, do not care about Reader

What acrobat version is installed?   Example:  Adobe Acrobat XI PRO,  Adobe Acrobat XI Standard

What is the acrobat version number?        Example:  11.0.17,     11.0.15, etc.

Last User?

Last Inventory?      Example:   8/11/2016  22:06,  etc.

0 Comments   [ + ] Show comments

Comments


All Answers

0
I think i was able to get my qurery to work.  Not very good with SQL so if anyone has suggestions that would be great.

SELECT MACHINE.NAME AS SYSTEM_NAME, 
  MACHINE.USER_NAME, 
  MACHINE.LAST_INVENTORY,
  SOFTWARE.DISPLAY_NAME, 
  GROUP_CONCAT(SOFTWARE.DISPLAY_VERSION) AS VERSION
FROM MACHINE 
  LEFT JOIN MACHINE_SOFTWARE_JT 
    ON MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID 
  LEFT JOIN SOFTWARE 
    ON SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
WHERE 
  SOFTWARE.DISPLAY_NAME like "%Adobe Acrobat XI%"
GROUP BY MACHINE.ID
ORDER BY SYSTEM_NAME;
Answered 09/08/2016 by: bmather
White Belt

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ