List View of Reports Embedded in Dashboard

[JosephW1]

Hello,

I am trying to find where the data is housed that stores which reports have been embedded in any given dashboard. I am hoping that this is stored in a table and I am hoping to be able to view it in list view. Does anyone know where this data can be found?

(I found the I want to be able to see which widgets are on a dashboard -- in a table. How can I do this? article, but the table mentioned in that post - pa_widgets - only houses information for PA widgets, not normal reports.)

Kind Regards,

Joseph

[JosephW1 · Accepted solution]

Sarah - Yes, the table is Portal [sys_portal].

That table houses a record for each object that has been placed on a page and stores the string of the object's name in the Summary field.

Then, using the SysID of the Portal record, you can discern the object's details from the Portal Preference [sys_portal_preferences] table by looking within its Portal Section field for the given SysID.

It took me a while to find these bits and pieces, but I have put them all together to provide a tree-view. I have created the Dashboards & Reports Tree View Project community question to explain how to put these tables together to enable a tree view and to seek improvements.

I'm glad to hear that someone else is interested, too! 🙂

[Sarah36]

I started adding a note to the Description of each report that says which dashboard it's used on. Then I can go to the Reports table to filter on that field. This way lets me export so I don't have to use the tree view and manually copy things down.