Run a report of computers that have acrobat installed.

Question

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.

Answer

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;

Scripting