/build/static/layout/Breadcrumb_cap_w.png
09/07/2016 1354 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