How to Find and Count Dynamic Dashboards in Your Salesforce Organization

To locate all dynamic dashboards within an organization, the following methods may be used: 

• Use Workbench
• Create a report to find all Dynamic Dashboards
• Use an API tool to help you locate all Dynamic Dashboards
• Manually check personal folders

Steps to use Workbench to query:

1. Go to Workbench
2. Tick I agree to the terms of service 
3. Click Login with Salesforce
4. Choose "SOQL Query" on Jump to.
5. Choose "Dashboard" for the Object.
6. Hit Select
7. Choose the columns you want to show on under Fields
8. Filter results by Type = LoggedInUser

Query would look like this - SELECT FolderName,Title FROM Dashboard WHERE Type = 'LoggedInUser' OR Type = 'MyTeamUser'

Note: These steps are provided for additional help. Salesforce does not provide assistance with the above suggested approach on Workbench. 
 

Create a report to find all Dynamic Dashboards:

1. Follow the steps listed to Create a Custom Report Type using “Dashboards” as the main object.
2. Create a new report using the newly created Dashboards Custom Report Type.
3. Within your report, be sure to show All Dashboards.
4. Select the All Time range.
5. Add the Dashboard Running User field into the report.
6. Add the following filter: Dashboard Running User equals "Run as logged-in user, Let authorized users change running user"
7. The results will display all Dynamic Dashboards to which you have access. 

Though it is no longer possible to save Dynamic Dashboards in personal or private folders, they may have been saved there prior to this restriction. If this is the case, these dashboards may not be returned by a report using the method above. Using the API is almost always necessary in cases like this to find these “hidden” Dynamic Dashboards. 

Use an API tool to help you locate all Dynamic Dashboards

1. A SOQL query executed within an API tool can quickly locate Dynamic Dashboards
2. "SELECT Id,Title FROM Dashboard WHERE Type != 'SpecifiedUser'  " will return Dynamic Dashboards that are not in private folders. 
3. 'SELECT Id,Title FROM Dashboard USING SCOPE allPrivate WHERE Type != 'SpecifiedUser'  ' will return Dynamic Dashboards that are in private folders.

Manually Search Folders

Please use the following to learn  Locate Reports and Dashboards Stored within Personal or Private Folders


Notes:

• Dashboards and Reports in Personal folders will count towards your limit but won't necessarily show up in reports.
• Deleted Dynamic Dashboards are moved to the recycle bin and will still consume Dynamic Dashboard allotments.​​​​​​
• It is a best practice to empty the recycle bin and wait until the following weekend for the emptied recycle bin to be purged.
• It is a best practice to convert the dashboard into a Static Dashboard Type before deleting it.
• ​If you would like to purchase additional dynamic dashboard licenses, please review the article Increasing maximum number of dynamic dashboards. 

See Also:
View and Restore Your Recycle Bin in Lightning Experience