/build/static/layout/Breadcrumb_cap_w.png

Query/Report for Scheduled Script Success

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. 

0 Comments   [ + ] Show comments

Answers (1)

Posted by: chucksteel 6 years ago
Red Belt
0
Not sure if this is exactly what you are looking for, but hopefully it helps:
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

 
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