To export the list of Reports attached to the Dashboards

Malathi3
Tera Contributor

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?

14 REPLIES 14

Do you have any reports in your PDI that are from Core UI?

check out sys_report table

I think all new PDI are on the new platform 

I checked and there are reports configured to the Dashboard. But the Database View gives empty results.

 

Malathi3_1-1769099450526.png

 

 

Malathi3_2-1769099463082.png

 

just for the sake of testing if I was in your position I would create a new dashboard in core UI and add two test reports to it and see if you get data I am wondering on my end why is not working for you

Hello Everyone,

 

I followed the same steps mentioned in the community article and configured the Database View . I am able to get the Report SysID but I also need Dashboard SysID. How to configure it?

 

Malathi3_0-1769503186623.pngMalathi3_1-1769503210902.png