Machines Failed For Scheduled Scripts
I have a number of scheduled scripts with Smart Labels of machines attached. Does anyone have a SQL query for determining which machines failed, or did not report back the KBOT_LOG. I want to build a report for a specific time range and script name to determine failures. Some of what I have figured out is if a machine fails no entry will be written to the ORGX.KBOT_LOG table. But I cannot find a table that has failures for scheduled scripts. One direction I was going to try was checking the machines in the label that do not have entries in the ORGX.KBOT_LOG table using the following tables. ORGX.MACHINE_LABLEL_JT, ORGX.LABEL, ORGX.MACHINE, and ORGX.KBOT_LOG. Thanks!