Is there a way to tell if a Report is part of a Dashboard?

[LookCal]

I have been tasked to clean up our Reports. We have several Reports and I am trying to clear out the ones we no longer use. I am worried about deleting Reports that may be used on a Dashboard. Is there a way to tell if a Report is being used/displayed on a Dashboard?

[Ankur Bawiskar · Accepted solution]

Hi,

check these links

How can I tell if a particular report is being used on any dashboards or homepages?

How to list reports included in a dashboard

How to find out which dashboards are using a particular report

Regards
Ankur

[maggieo]

I find easier to just go to the report from all report menu

Click on the name of the report

Click on Dependency assessment

Click on the used by until you get to the dashboard (if it's used on a dashboard)

[Justin Docken]

I had the same question and am pursuing the following solution:

I need a systematic way to determine which Dashboard(s) each report belongs to.

We are looking to create a new database view to contain one record per Report from the [sys_report] table and include a new Dashboard field (Example: "Related Dashboards") indicating which Dashboard(s) [pa_dashboards] each report belongs to. If a report belongs to more than one Dashboard the "Related Dashboards" field will list out all the Dashboards the report belongs to.

I'd also hoping to tie in a 3rd table [report_stats] into the the new database view to include the following fields:
1.) "Last run"
2.) "Runs"
3.) "Runs on page"
4.) "Run time"
5.) "Recent run time"

... for each report so I don't have to merge the [report_stats] table with the new database view manually.

Fields to include on the new database view would be the common fields from the [sys_report] table such as Title, Type, Table, Created, Created by user, User, Updated, Updated by, Is published, Is scheduled, and Is real time.

For reference, here is the community article Adam Stout wrote up for how to accomplish creating this new database view:
https://community.servicenow.com/communityid=community_question&sys_id=4f6e7d6d1b0a5450305fea89bd4bcbc8

The suggested Database View/table name is u_report_on_dashboard.

Once this Database View has been created, I will be able to report off of this as though it is a standard table.

[Marco Perez1]

1. Created a Business rule on sys_report table

    a. on display

    b. Script Attached file.

2. Created UI Action

    a. Client: true

    b. onclick: showDashboards()

    c. Condition: g_scratchpad.relatedDashboards != ""

script (attached file)

/****Please mark this as helpful if this works for you.*****/