Kace reports: Specific software installed within a date range
So being an utter novice to scripting, and still pretty new at KACE in general, I'd like to setup a report that will tell me the system name and logged in user of any system with a specific piece of software. Not to difficult, I can do that part no problem. What I need now is the same report to show me the install date of said piece of software. That's the part I just can't sort out. It doesn't seem there is any reference material for Kace reporting where I could glean this information from. Any ideas?
SELECT MACHINE.NAME AS SYSTEM_NAME,USER_LOGGED,GROUP_CONCAT(DISTINCT SOFTWARE.DISPLAY_NAME SEPARATOR '\n') AS SOFTWARE_DISPLAY_NAME_GROUPED 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 '%specificsoftwaretitle01%') GROUP BY MACHINE.ID ORDER BY SYSTEM_NAME,USER_LOGGED