To export the list of Reports attached to the Dashboards

[Malathi3]

Hello Everyone,

We are planning to migrate Core UI Dashboard to Platform Analytics Dashboard. We are able to get the total count of Dashboards and Reports directly by accessing the table.

But to cross-check, we are looking for the list of Reports that are attached to the Dashboard.

Could you please help with the script to get the list of Report Name + the corresponding Dashboard Name?

[GlideFather]

Hi @Malathi3,

I just added a report (eventually a data visualisation) to a dashboard and then I checked the update set to see what changes were auto-created, and it's these tables shared below:

Tables:

• sys_ui_section
• par_dashboard_tab
• par_dashboard_widget
• par_dashboard_permission
• par_dashboard_visibility
• par_dashboard_canvas
• par_dashboard_user_metadata

I have breifly inspected the tables but haven't found much, perhaps the relationship between report and dashboard is set o na field that is not visible directly on these table's forms, or perhaps some related tabs or any other dependencies.

If you will investigate the tables more closely, perhaps you find your answers.. good luck 😛

[Mark Manders]

The migration only inactivates the old dashboards. You can still access them and compare. And the migration tells you any issues.

[Dr Atul G- LNG]

Agree with @Mark Manders 

Migrated and then compare.

[Malathi3]

Hello All,

Thanks for the reply.

I am just looking for a simple script which gives the Dashboard name and the associated report name in it.