
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-16-2020 11:18 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-21-2020 04:39 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-16-2020 11:38 AM
Hi,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-16-2020 01:52 PM
sys_dashboard_detail gives you information on the legacy dashboards (that pre-date homepages), this is probably not what you are looking for.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2020 06:04 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2020 06:04 AM
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
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.