/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Query/Report for Scheduled Script Success

05/01/2018 503 views
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

Comments


All Answers

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

Answered 05/02/2018 by: chucksteel
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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