Microsoft Dynamics CRM (Archived)

List of all Dashboards

(0) Share

Report

Posted on by Community Member

I need to get list of all the current dashboards in the system,

I went to: Settings>>Customization>>Customize the system>>Components>>Dashboards.

I can see a list of dashboards , but it does not show all the dashboards

How can get list of all dashboards in all different modules

Many Thanks.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (3)

Frank Lee 4,617 on at

Like (0)

Report

RE: List of all Dashboards

Via .Net program

Link to Dynamics 365 SDK:

docs.microsoft.com/.../download-dynamics-365-sdk-v9

Was this reply helpful? Yes No
Verified answer

Tim Dailey 440 on at

Like (0)

Report

RE: List of all Dashboards

Where do you enter this query language?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: List of all Dashboards

thank you it was great help

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: List of all Dashboards

thank you , this worked fine for me

Was this reply helpful? Yes No
Verified answer

Nithya Gopinath 17,078 on at

Like (0)

Report
RE: List of all Dashboards

Hi Shaka,

Use the following query expression to retrieve system dashboards. You should add the condition type is 0.

QueryExpression query = new QueryExpression("systemform"); query.ColumnSet.AddColumns(new ColumnSet{"formid","name","isdefault","description"}); query.Criteria.AddCondition("type", ConditionOperator.Equal, 0); query.Orders.Add(new OrderExpression("name", OrderType.Ascending)); return orgService.RetrieveMultiple(query);

Hope this helps.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: List of all Dashboards

Please try this:

select * from systemform where type = 0

0 is the type for dashboard.

https://msdn.microsoft.com/en-us/library/mt607589.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: List of all Dashboards

As you may see above total is 23 records

while it gave a number of 1039 record as a result of the query:

select * from systemform

thanks

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

RE: List of all Dashboards

Hi Shaka,

Can you check how many dashboards you see under Settings>>Customization>>Customize the system>>Components>>Dashboards. If it is over 1000, then you will be definitely having these much system dashboards.

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: List of all Dashboards

i query both user forms and system forms using the below simple queries as i'm not that expert how and where to use that code

1- select * from UserForm

2- select * from systemform

the 1st one gave me few records, but the 2nd one for system forms resulted more 1000 of records, im not sure if i have that much number of dashboards in the system

any advise?

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

RE: List of all Dashboards

Hi Shaka,

To see both system and user dashboards, you can write the code as shown in the link below.

msdynamics2011.blogspot.com/.../get-list-of-system-and-user-dashboards.html

Hope this helps.

Was this reply helpful? Yes No