AnsweredAssumed Answered

SQL query for showing monitor of a Scheduler

Question asked by JessicaHolle607440 on Jun 8, 2015
Latest reply on Jun 10, 2015 by JessicaHolle607440

I have some scripts for the Automic Automation Engine to display some information to our wiki or to Icinga. For example, showing the entries of a scheduler, Information about Jobs in the short term scheduler, Jobs with ended not ok, Workflows with inactive Steps, Workflows with conditions an so on. All these things are solved with an sql-query against the database. 

Now I would like to have a sql query which displays the monitor of an scheduler. Sometimes a workflow name changed (and somebody didn't change this in the schedule object) oder a calendar name didn't exist. 

Has anybody an idea to solve this? 

Best wishes