16 Replies Latest reply: Feb 24, 2016 4:50 PM by Dicky Mohanty RSS

    Load the Historical Data in Governance Dashboard

    Dicky Mohanty

      Hi All,

       

      Need to load the historical data into the Governance Dashboard - mainly into the SessionTaskAuditMaster table to show the performances in the Previous Timestamps.

       

      I followed one approach -

      1. Converted the table into a QVD and added a Date Field to extract and store data into the QVD from today onwards on daily basis.
      2. Loaded the table into the Model by removing the Hidden Script.

       

      But not sure how to get the previous dates from the logs. Could someone please help me more on this -

      1. What is the source for the Governance Dashboard?
      2. How to read those historical data and bring into the model (can we edit our own script there)?
      3. Mainly needed for 'Publisher Task "Last Run" Status' sheet