2 Replies Latest reply on Oct 4, 2016 4:42 PM by Matt Coles

    How to find Avg refresh time of Extract?

    fauziajalali.jalali

      Hi awesome people,

       

      I have created admin view of data extracts with following fields..  datasource names, owner of datasource, workbook names, connection name and type, refresh schedules and average refresh duration  of extracts

       

      I am using 3 tables currently, datasources, data connections, workbooks. PFA

       

      datasources to gives me extract info/extract name

      Data connections for connection name/host name, type ( oracle, vertical, excel..)

      Workbook name to get name of workbook

       

      Not sure where to get refresh schedule duration? I assume it is when Refresh started and when it ended ...Started time- Complete Time.

      In my Data sources table i have 'extracts_refreshed_at' ,

      extracts_incremented_at,created_at, updated at

      Source: Workgroup DatabaseData Dictionary

       

      Do i need to join any other table (like Background jobs) and how?

       

       

       

      Any help is highly appreciated. thanks thanks thanks!!!