Report last run date

[daved999]

Hi Everyone,

I'm currently trying to remove duplicate and redundant versions of global reports created by previous administrators and ex-staff to simplify the environment.  Basically, I need to determine which reports are actively being utilised or are running as scheduled jobs.

As per the advice in some other threads, I am now aware of the "last run" field in the Reports -> Report Statistics field.  Unfortunately, this view lists all reports as created by "system."   At this stage, I really just want to be able to target reports created by specific users. 

Although I could simply delete reports created by inactive accounts, I know there are some scheduled jobs which are still calling reports set up by these ex employees.  Any suggestions?

Regards,

David

[Adam Stout]

The records in report_stats are all created by system, but you can dot walk to sys_report (via the report field) to get who created or updated the report last.

[daved999]

Something that may be worth mentioning... I had some initial concerns when I was checking some of the "scheduled reports."   These jobs do not appear to update the "last run" date on existing reports.  Perhaps because the Report Statistics function is based on whether the creator has executed the report and not by an automated task?

[Adam Stout · Accepted solution]

report_stats tracks if anyone executed the report, not just the creator.

For the scheduled reports, I would add a message to everything scheduled by people no longer at the company.  Add something like, please click here to continue receiving this or click here if this report is no longer needed.  Or a message that this will be removed unless they opt back in.

[daved999]

Thanks for the tips Adam, it's much appreciated.