ServiceNow Reports (New UI): See Open or Closed Request Tasks

The See Open or Closed Request Tasks report shows the total number of active request tasks (catalog tasks) in assignment group(s), grouped by whom each task is assigned to.

You can make a copy of this report and modify the copy to suit your own needs.

In this article:

Running and making a copy of the report

  1. Click View / Run under Reports in the Application Navigator menu on the left. A list of available reports in ServiceNow loads, depending on your access privileges.
    ServiceNow%20view-run%20reports.PNGx
  2. Make sure Global or All is selected as a filter at the top of the Reports screen.
    A screenshot showing the location of the All Reports button at the top of the reports screen
  3. Search for Open Request Tasks (My Groups) - Template.
  4. Click on the Data Tab.
  5. Rename the report by changing or replacing the text in the Report name field from the Data Tab.
    The Data Tab selected with a cursor in the Report name field
    • Most of the time you will be making the current report yours by replacing the word Template with your Internet ID.
    • If you are changing something specific about the report in any meaningful way, make sure the title appropriately reflects the content AND remember to end your title with your Internet ID.
  6. Click the arrow to the left of the Run button and select Insert and Stay.
    The Insert and Stay option in the expanded menu .

A message will appear saying that the report has been created, and there will now be a Save button next to arrow.

Modifying the report

You will likely want to make modifications to this report in order to make it useful to you. Some common changes are outlined below.

In the New Reports UI, the filters used in the report are collapsed by default.  Click the Open Condition Builder button open-condition-builder-filter-button-20180815.pngxto begin to modify the report using the guidelines below. 

Reports configuration view with arrow pointing to show/hide Filter icon.

Changing or updating the Assignment Group

If you belong to more than one Assignment Group and want to only see results for one assignment group:

  1. Find the Assignment Group filter.
  2. Either type to get predictive text and choose from a list or use the Search Box to find and populate the desired Assignment Group.
    Kingston Assignment Group Filter with drop down list of different groups
  3. To get the report with these changes click Run.

Viewing closed Request Tasks instead of active ones

  1. Change the Active filter using the dropdown menus to select the field name Closed, and leave the default filter operator of on and select your desired date range.
    Kingston Date change filter with calendar drop down options
  2. Click on the Configuration Tab.
  3. Use the drop down menu for Group By and choose the Closed By field.
    Kingston Report Configuration tab Group by menu open with Closed by option highlighted
  4. To get the report with these changes click Run.
  5. If sending this report to someone you will want to Save the report with another name that includes the word "Closed" so as to avoid confusion.

Changing the report type

You can Change the Report Type if the current type is not meeting your needs. There are many different types you can try to see which best represents your data.

Running and saving the report

Once you've modified the criteria for your report:

  1. Click Run to make sure it contains the desired data and is displayed how you want.
  2. Click Save so you can use the report in the future.

Additional Information