How To Identify if a Report is hosted on a Homepage/Dashboard?

[Soumyadip1]

Dear Team

Hope you all are doing safe and sound!

We have recently initiated a Reporting Management Project in our organization. As part of the same, I have consolidated a list of Reports which have not run since a significant amount of time.

Now whilst I am validating the usage and requirement of these Reports, with the Report Owners, typically a questions comes up that "Are these reports tied to any of the Dashboards or Homepages?"

Any way I could take to look up the same piece of information?

PS: I am a System Administrator.

Appreciate your assistance in advance!

Regards
Soumyadip

[Adam Stout]

It is not super easy, but you can do it (for reports) by looking at sys_portal_preferences where the "Name = sys_id" and the value is the sys_id of the report.  You would then need a view to join this to sys_portal to  tabs to dashboard tabs.

[Soumyadip1]

Wow! That sounds interesting! Lemme give that a shot and come back 🙂 

[Adam Stout · Accepted solution]

The two joins you don't see are here:

p.sys_id = prefrend.portal_section && prefrend.name = 'renderer' && prefrend.value = 'com.glide.ui.portal.RenderReport'

p.sys_id = prefrep.portal_section && prefrep.name = 'sys_id'

This will let you see all the reports on a dashboard and all the dashboards a report is on.

[Soumyadip1]

Wow! You are a star @Adam Stout !!!

I cant thank you enough for all the efforts you have put in to help me through this.

I am gonna try this out for sure.

Take care and stay safe my friend! 

Cheers!

Soumyadip

[Justin Docken]

Just to confirm, using the database view (u_report_on_dashboard) will there be separate "table" entries for the same report which is on multiple dashboards?

Example:

Report Name           Dashboard Name

Report123               Dashboardabc

Report123               Dashboardxyz