Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display Last Dataset Refresh On Report

I have users that want to see the Last DATASET refresh time on their reports.  So if the dataset refreshed at 1:00 and they view the report at 2:30, 1:00 should be displayed.  This is very useful in ...
dataset refresh
  • cbarrettEM's avatar
    cbarrettEM
    6 years ago

    For a SQL data refresh it will be stored in the logs

    ReportAction 19 is Data Refresh, so something like:

    select max(timeend) as LastRefresh from ExecutionLogStorage where reportaction = 19 and ReportID = YourReportID

cbarrettEM's avatar
cbarrettEM
Advocate I
6 years ago

For a SQL data refresh it will be stored in the logs

ReportAction 19 is Data Refresh, so something like:

select max(timeend) as LastRefresh from ExecutionLogStorage where reportaction = 19 and ReportID = YourReportID

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you.  We are working through some steps to get this automated, but I think this is the answer.  Was disappointed that I can't just get high level logging and have to get everything,