Servicenow walkthrough

ServiceNow reports help you monitor and analyze data within the platform. Due to the varying nature of data and API constraints, specific prerequisites and configurations are necessary to ensure smooth and efficient data retrieval.

Prerequisites for fetching reports from Servicenow

To ensure API requests to Servicenow have enough time to complete, extend the transaction timeout settings.

Procedure

1. Navigate to System Definition and select Transaction Quota Rules.
2. Modify the following Timeout settings:
   • REST Import Set API request timeout: Set to 600 seconds.
   • REST Aggregate API request timeout: Set to 1800 seconds.
   • REST Table API request timeout: Set to 600 seconds.
   • REST Attachment t API request timeout: Set to 600 seconds.

ServiceNow reports

Table dependency

Reports in ServiceNow are primarily dependent on table names. You can specify the tables to include or leave the input empty to pull data from all available tables. Ensure that you have the necessary user access to the tables you are querying.

If certain tables are missing due to being tagged as attachments, you can manually include them by adding their names to the Manual Insert Tables section.

Text query parameter in reports

To filter specific table records, use the Text Query parameter. You can combine the query with other parameters and time intervals to refine the data retrieval.

Example Query

Text Query: priority=2^calendar_stc>=6862 You can also specify additional time filtering within the text query.

Example of Advanced Setup

The data is filtered dynamically by time interval sys_created_on and sys_updated_on. To retrieve only non-closed records, add closed_at=null to the text query.

Time-dependent reports

Reports include time dependencies based on a time field. The default field used is Sys Created On. You can specify additional time filters using the text query.

Selecting a time period

Time-dependent reports support two types of time periods:

1. Date Range
   • Start Date: Required.
   • End Date: Optional. If left empty, data will be pulled up to the current time of the river's run.
   • Timezone Offset: Specify to adjust dates based on the offset.
   • Last Days Back For Each Run: extend the start date to include data from a specified number of days prior.
   • Example: Date Range: From 01/03/2020 to 30/03/2020.
2. Predefined Date
   • Day: Yesterday.
   • Week: Week to date, Previous week, Previous week to date.
   • Month: Month to date, Previous month, Previous month to date.
   • Year: Year to date.