Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Phil WaltonPhil Walton 

How many Dynamic Dashboards are being used?

Hi

In our Enterprise Edition I know we have a limit of 5 Dynamic Dashboards. When I try to set up a new one, it says 'you have reacjed your limit'. However, I can not find a list of the 5 that have been set up. Its a complex Org with 1600 Dashboards, how can I find which ones are Dynamic?

Thanks

Phil

Jia HuJia Hu
Use Apex to find out the Dynamic Dashboard, like,
List<Dashboard> da = [Select Id, Title, RunningUserId, Type from Dashboard Where Type = 'LoggedInUser'];

doc,
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_dashboard.htm
Phil WaltonPhil Walton

Hi Jia

Many thanks for your suggestion! Actually I found another option (which I needed to work on a bit). Which is to build a custom report type for Dashboards. As long as you add all the fiels, especially 'Dashboard Running User', then that will identify which are theDynamic dashboards.

Many thanks!

Phil
Jia HuJia Hu
Hi Phil,

That's great, thanks for sharing.

Jia
Terry Downing 3Terry Downing 3
Thanks for this.

Another option for DBAmp Users
SELECT D.Title, D.Type FROM dbo.Dashboard AS D
WHERE Type = 'LoggedInUser'

Also available from Developer Console
Query Editor
SELECT Title, Type FROM Dashboard WHERE Type = 'LoggedInUser'
Execute