I have to create a report on Dashboards which haven't been run in a long time. I could not find last run date
on Dashboard. How can I create this report?
1 Answer
I don't think statistics are kept on dashboards, but you can generate a report on Reports and find the Last Run date for various reports. Since Dashboards are collections of reports that might be a good starting point.
Update
I found a Salesforce knowledge article that indicates a dashboard's "refresh" date is not reportable, though they offer something of a workaround.
- Create a Custom Report Type (CRT) based on Reports and Dashboards as the child element.
- Create a report using the new CRT
- Sort by dashboard and check the report's Last Run Date.
With the reports grouped by Dashboard this may give you more information, though reports used in multiple Dashboards are still a problem.
-
Thanks Mike. I have been doing the same but it's bit tedious because a report can be related to multiple dashboard. Now if report A is linked to Dashboard B and C. And, Dashboard B ran last Month it changed report A Last Run date. pheeww.. Oct 8, 2013 at 12:36
-
Is there a simple to find out the same ? thanks a lot in advance. Oct 8, 2013 at 12:37