Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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