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

Soumyadip1
Tera Contributor

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

1 ACCEPTED SOLUTION

 

find_real_file.png

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.

 

View solution in original post

9 REPLIES 9

vinitha3
Tera Guru

Hi,

You can find that information in the Admin Console of the instance..

Navigate to Admin Console as shown below..

Click on "Dashboards"

In the "Dashboards" window, click on the top left drop down, and switch from default "Dashboard Groups" to "Dashboards".  On the tabs below, click on "Report" tab.

This should show you the list of all the reports being used for a particular dashboard.  You can export the result to a report.

find_real_file.png

You can also see it in this table sys_dashboard_detail ...
 
 Hope this helps you..
 
Thanks,
Vinitha Vijay
 
PS: Please mark correct or helpful if it does...

Adam Stout
ServiceNow Employee
ServiceNow Employee

sys_dashboard_detail gives you information on the legacy dashboards (that pre-date homepages), this is probably not what you are looking for.

Thanks for your response Adam

However, given the scenario, I have a bunch of reports, and I am trying to find out if these are tied to any of the Dashboards/Homepages or not?

Is there any way we could achieve that?

Regards
Soumyadip

Thanks Vinitha

I guess this shall help in locating the reports hosted on a particular dashboard.

However, given the scenario, I have a bunch of reports, and I am trying to find out if these are tied to any of the Dashboards/Homepages or not?

Is there any way we could achieve that?

Regards
Soumyadip