How to find all the reports added to the dashboard

[v-paulp]

Hi all,

Is there any table in ServiceNow on which I can find out the reports name which is part of dashboard?

I can find it from admin console but I can not query to that table.

Reason I am asking this we have a catalog item  where when an user select the dashboard name from a variable and on the second variable we want only those reports should show which is part of that dashboard.

[Mark Manders]

Yes, that table exists, but not as easy to access as just a table.
You can go to the Dashboard properties to find the path to the report from the dashboard. That will take your through:

• pa_dashboard (Dashboard)
• pa_m2m_dashboard_tabs (Dashboard Tabs)
• pa_tabs (Tab)
• sys_portal_page (Portal Page)
• sys_portal (Portal)

On this last one, you will find the reports in the 'summary' field. So with a lot of 'where's' you will eventually get from the reports to the dashboard.

[Harish Bainsla]

Hi @v-paulp 

You can find that information at Admin Console.

Navigate to Admin Console.

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

[v-paulp]

Hi @Harish Bainsla 

How can I query to this table?

Because I want to show all the reports to a catalog item variable drop down list according to the dashboard name selected to the previous variable.

[MireilleEdwards]

Hello,

You might find this article written by Adam Stout to be helpful

View Reports on a Dashboard and Dashboards using a... - ServiceNow Community

He goes into the creation of a database view to provide the sort of information you're looking for.  Hope this is helpful.

Mireille