Skip to Content
0
Former Member
Aug 28, 2015 at 02:38 AM

How to find list of reports that were refreshed during given date/time range?

201 Views

We have Auditing turned ON in BOXI 3.1.

I am trying to find list of reports that were refreshed within a given time range. Some of these reports could have either finished refreshing or could still be running during the given date/time range (because of volume of records to be retrieved).

The reports that came out of the box using the activity universe doesn't seem to help with this. Is there a back end SQL that can be directly run against Auditor Schema? I see that AUDIT_DETAIL and other such tables are present in this schema. But not exactly sure which event type or which audit event will provide the information I am looking for.