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?
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.
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.