I'm working with Tableau 9.0 and I'm trying to find where I can relate the Workbook with the Programmed Schedules that I assign each one of those since publication or Tableau Server Platform
I see all the columns in Workbook table and I can't relate with Schedules table inside the workgroup database. (The columns of Workbook are listed below).
Where I can find a Table that allow me to do the Join between schedules and the Workbook?. I'm trying to make a dashboard where I can compare the last time it was updated and when it should updates (Schedule and workbook list), I want to avoid to doing by hand because the dashboard list will also being increasing. At the same time I think that the table historical_events is only showing the day to day activity that give a more dynamic view and I'm trying to find a "dictionary table" where I can see workbook and schedules only.
Note : Also in the table historical_event the column hist_schedule_id doesn't match with the schedules ids in schedule table.
I think you are looking for the tasks table that is the link between workbooks and schedules. At least that is what I did to find the schedules for my extracts.
_datasources joined to tasks on _datasources.id = tasks.obj_id (substitute _datasources with _workbooks)
tasks joined to schedules on tasks.schedule_id = schedules.id