List View of Reports Embedded in Dashboard

JosephW1 · ‎12-19-2019

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 · ‎04-29-2020

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! 🙂

View solution in original post

SanjivMeher · ‎12-19-2019

I believe it is the sys_dashboard_detail table. The board id is the dashboard and Gauge ID is name of report and type is wether it is a report or count etc.

Please mark this response as correct or helpful if it assisted you with your question.

JosephW1 · ‎12-20-2019

Thanks Sanjiv, but that does not appear to be the table. I have a couple dozen of custom reports in my PDI placed on dashboards, and none of them appear in that list.

JosephW1 · ‎12-23-2019

Thanks Sanjiv, but that does not appear to be the table. I have a couple dozen of custom reports in my PDI placed on dashboards, and none of them appear in that list.

Sarah36 · ‎04-28-2020

@JosephW - Did you ever figure this out? I'm looking for the same thing.