Reports list

View a list of predefined reports and create custom reports from the Reports list.

Standard platform ACLs regulate access to reports in the reports list. This regulation impacts user access to certain reports. For further information on ACLs and reporting, see the article Reports list access regulated by ACLs [KB0546694] in the HI Knowledge Base.

Note: You can open the Reports list by adding /report_home.do to your instance URL. To only show reports that are marked as favorites, add the ?sysparm_favorites=true parameter.
You can filter the Reports list with the following tabs:
Table 1. Reports list
Tab Description
My reports Displays reports that you created.
Group Displays reports that you created, reports that have been shared with you, and reports that have been shared with the groups you are a member of. You can view additional information about an individual group report by pointing to the report icon.
Global Displays reports to users who have the itil role.
All Displays global reports, group reports, and my reports.
Figure 1. Reports list tabs
The following tabs are available on the Reports list for users with the report_admin role:
Table 2. Reports tabs
Tab Description
Heavy Displays the reports that take the most time to generate. Change the glide.report.new_home.heavy property to adjust the number of heavy reports that are displayed.
Unused Displays reports that have not been used for some time. Change the glide.report.new_home.unused property to adjust the number of days that reports must remain unused before they are displayed under this tab. This tab also includes reports that have never been run.
Most used Displays the most used reports. Change the glide.report.new_home.most_used property to adjust the number of most used reports that are displayed.
Users with report_admin or admin roles only can also view the following columns on their Reports list.
Table 3. More columns
Column Description
Scheduled Indicates if the report is scheduled to run in the future. Reports can be run periodically and then emailed.
Last Run Date Displays the date and time the report was last run.
Runs Displays the number of times the report was run.
Runs on Page Displays the number of times the report was run from a homepage gauge. Refreshing the homepage does not always increase the number of page runs. The number is only updated when reports are not cached on the server.
Recent Run Time Displays the average time in milliseconds that it took to run the report, based on the last 25 times.
Run Time Displays the average time in milliseconds that it took to run the report, based on all runs.
Published Displays a check mark icon (The check mark icon) to indicate that the report is published.

Searching reports

You can search for reports from the Reports list. Only reports you can access appear in search results.

Search suggestions appear depending on the search string. Use search suggestions to search for reports by title keywords, for a specific report by name, or for reports on a specific table.
Figure 2. Report search suggestions

You can sort and filter the search results using the standard report list controls, such as by clicking tabs, column headings, or the favorites icon (The favorites icon).

View favorite reports

You can manually mark a report as a favorite by clicking the star icon beside the report title.

About this task

To toggle between showing only favorite reports and showing all reports, click the star icon in the list header.

Figure 3. Report favorites
Report favorites

A report is automatically marked as a favorite when you open it. The View/Run reports list layout uses the general Automatically Add Favorites per-user setting to define the preferred behavior. You can modify this behavior by clicking the menu icon The menu menu in the application navigator. Toggle the option to enable or disable automatically adding favorites. The setting applies to the selection of both application menu modules and reports.

Reports list URL parameters

You can add parameters to the Reports list URL to filter the list before it loads.

Reports list URL structure

The URL structure is https://<instance-name>.service-now.com/report_home.do?<parameter_name>=<parameter-value>.

For example, the URL https://yourbusiness.service-now.com/report_home.do?jvar_selected_tab=MyReports returns the Reports list with the My Reports tab selected.

Parameters

The following parameters are available for Reports list URLs:
Parameter Possible values
jvar_selected_tab Shows the Reports list with the specified tab selected. Use these values:
  • myReports
  • groupReports
  • globalReports
  • allReports
jvar_search_table Filter reports created on a specified table. For example, the parameter jvar_search_table=incident shows only the reports created on the incident table.
jvar_list_order_by Sorts the list on one of these columns:
  • type
  • title
  • table
  • modificationDate
  • scheduled
  • published
  • createdBy

For example https://yourbusiness.service-now.com/report_home.do?jvar_list_order_by=table returns the list sorted by the source table of the report.

Note: Use jvar_list_sort_direction to specify ascending or descending order.
jvar_list_sort_direction Specifies the direction of the sort.
  • asc — Sorts the list in ascending order
  • desc — Sorts the list in descending order
sysparm_reportquery Filters the reports with names that contain the specified value, for example: sysparm_reportquery=Active returns reports with the string Active in the title.
jvar_search_created_by the user who has created the report for example: https://yourbusiness.service-now.com/report_home.do?jvar_selected_tab=allReports&jvar_search_created_by=itil returns the reports created by the user with user name itil.
sysparm_query Enables you to filter on any condition in platform condition builder format. For example, https://yourbusiness.service-now.com/report_home.do?sysparm_query=titleSTARTSWITHPRB&table!=incident.

For more information, see Condition builder.

View a report shared with specific users or groups

If administrators have added and enabled the glide.report_home.group_report.show_usr_grp system property, you can configure the Reports list to show the names of the users and groups that reports are shared with.

About this task

You set the Visible to setting to Groups and Users to allow other users to view your reports. Shared reports are those where the setting is Groups and Users.

Procedure

  1. Navigate to Self-Service > My Profile.
  2. Click Reporting Preferences.
  3. Select the Show first group or user name for group reports, on the reports home page check box.
  4. Click Save.

    After you enable this option, the Group reports table displays a Shared with column with the names of the users and groups that the reports are shared with.

    Shared with
    Note: Users who configure the Reports list to show only shared reports may experience increased page load times.

Customize the Reports list

On the Reports list, you can show or hide columns, sort reports, and view general information about reports.

  • To show or hide columns in the list header, click the gear icon (The gear icon) at the right side of the header bar and then switch columns on (The toggle on icon) or off (The toggle off icon) in the Configure View settings. The number of columns you can switch on and off depends on your user role.
  • To sort reports in ascending and descending order by column, click the column in the list header.
  • To view general information and statistics for a report, point to the report title.