Scripts Status "Scripts Running" K1000 Report
I am attempting to create a report to show me all the machines stuck in the "Script Running" state due to the KBOT_Log not being pulled back. This can occur in our environment due to network connectivity issues. This is critical on my scheduled scripts since I do not get a list as in the Run Now Status. An article I read said to join the KBSYS.KONDUCTOR_Task KUID to ORGX.MACHINE.KUID with the completed being zeros. I was unable to find any KUID in the KONDUCTOR table that matched the ones in the Machine table. Can someone help with a query to determine scripts stuck in this state?
Community Chosen Answer
If it helps it looks like a lot of that data is in KBOT_RUN and KBOT_RUN_MACHINE. KBOT_RUN_MACHINE does have a MACHINE_ID field that would be a better join. In the description field however I do not see and "Running". It might be different in your Kbox.