Scripting

We are pushing out 3 software packages after hours using custom scripts and kicking them off with the scheduler.  These are NOT Run Now scripts, but scheduled scripts.  And there does not appear to be a way to view the results.  Ideally, the report would say here are the machines that got all 3 packages, here are the machines that failed on package X, here are the machines that failed on package Y, here are the machines that failed on package Z.  Or something like that.  Pretty much anything would be better than clicking on each machine's software inventory the following day and searching for the newly-installed packages.

It looks like the kbot_log_detail table might be a good place to start, but I'm not really sure what to look for. Also, if there is a log entry that signifies success/failure for script installations, I'm not sure what table/field I would join it on to match to a machine name.

Any guidance is appreciated. 

SELECT KBOT_LOG.ID, KBOT_LOG.START_TIME, MACHINE.NAME, KBOT.NAME, KBOT.ID, KBOT_LOG.STATUS, KBOT_LOG_DETAIL.TEXT
FROM ORG1.KBOT_LOG
JOIN MACHINE on KBOT_LOG.MACHINE_ID = MACHINE.ID
JOIN KBOT on KBOT_LOG.KBOT_ID = KBOT.ID
JOIN KBOT_LOG_DETAIL on KBOT_LOG_DETAIL.ID = KBOT_LOG.OUTPUT_DETAIL_ID
WHERE KBOT.ID = 1789