Need SQL query to find modified schedule tasks

Discussion created by daryl.brown_ACI on Jan 3, 2017
Latest reply on Jan 6, 2017 by Christine_Chavez_6412
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!