What table links the reports to the dashboards?

AN2023
Kilo Guru

Anyone know what table holds the link of which reports are on which dashboards?

 

I know it's not pa_dashboards or sys_reports... but I haven't found the correct one and the admin console doesn't show the name of the dashboard on the Reports tab. 🙂

Here's hoping someone knows the answer. 🙂

3 REPLIES 3

James Lewis
Tera Contributor

There is nothing out of the box that will show this. However this can be done with a Database View. 

 

Credit to Adam Stout who designed a database view to put this report together.

https://www.servicenow.com/community/performance-analytics-blog/view-reports-on-a-dashboard-and-dash...

 

I just put together this video on how to build this in 10 minutes flat.
https://www.youtube.com/watch?v=o1tLnhABMJs

 

If this helps you, please feel free to mark it as helpful. Cheers!

AN2023
Kilo Guru

Thank you 🙂

Cadmila21
Tera Contributor

Have you checked the pa_dashboards_reports table? It's worth a shot since it might hold the link you're looking for. Good luck! 🙂 #1wins