ServiceNow Reports (New UI): See Change Requests Closed in the Last Month

The See Change Requests that Closed in the Last Month report shows the total number of change requests in your assignment group(s) that were closed in the past month, grouped by their RFC status (Closed Complete, Closed Incomplete, Closed Cancelled).

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.
    Application navigator with arrow pointing to View / Run option in Reports section.
  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 All Change Requests Closed in the Last Month (My Groups) - Template.
  4. Click the name of the report in the list to run it.
  5. Click on the Data tab.
  6. 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.
  7. 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.
    The Assignment Group filter showing the drop down menu for changing the assignment group to a new group
  3. Click Run.

Changing the Date Range

  1. Find the filter for Closed.
  2. Leave the default filter operator of on and for criteria select the desired time range.
    The Closed Filter highlighted in the report Conditions area
  3. Click Run.

Viewing by Service Offering

  1. Change the Assignment Group filter using the dropdown menus to select the field name of Service Offering, leave the default operator of is, and either start typing a Service Offering name or use the search box to find and insert the desired value.
    Service Offering in the Conditions Area
  2. Click Run.

Viewing by Business Service

  1. Change the Assignment Group filter using the dropdown menus to select the field name of Business Service, leave the default operator of is, and either start typing a Business Service name or use the search box to find and insert the desired value.
    The Business Service Filter highlighted in the report Conditions area
  2. Click Run.

Adding or removing fields (columns) from your list

One of the reasons you might want to use a List Report is to get additional fields that don't show on default reports in ServiceNow or to remove fields that are not necessary from the defaults.

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