3

We have a pretty mature org, been going for 9 years and we have well over 3000 reports located in various folders. Now it's time for a cleanup since quite a large bunch of these haven't been run for years. I have identified over 2000 reports that haven't been run for a long time and have marked them for deletion. But a large portion of these reports are used in dashboard components so can't be deleted. And by running quickly over the API description of the Dashboard object, it seems that there is no way to use the fields in the object to filter. LastViewedDate and LastReferencedDate only contain data related to the current user, but I want to know when any user either opened the dashboard or edited it. Is the only way to do this is using the Metadata API? Or is there another way?

Improve this question
1
  • 2
    Does the advice here not help?
    – Adrian Larson ♦
    Commented Nov 11, 2016 at 14:04

1 Answer 1

Reset to default
0

Maybe you can figure out which reports belong to dashboard folders by querying:

[select Name, DeveloperName from Report Where FolderName LIKE '%Dashboard%' and DeveloperName IN :listOfReportDevNamesYouWantToDelete]
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .