Hello Automic community!
I'm looking for a SQL query (for v9) that will allow me to identify tasks within a schedule that have been modified (e.g., have that little clock-with-a-pencil icon). We're hoping to turn this into a daily report we can review to identify any modified (active) schedules that we may have forgotten to reload at turnaround.
I suspect this query is pretty simple...I just haven't been able to pinpoint which table houses the active schedule content. (I know JPP houses the schedule content, but I can't find the corresponding table for the active schedules.
Thanks for any help!