ServiceNow Import Settings
During the first data upload, set import and connection parameters to the ServiceNow instance. In the ServiceNow import settings window, configure the following (click to edit):
- In the Instance field enter your ServiceNow instance name. You can find it in the URL when logging in to the ServiceNow account.
For example, when you log in to ServiceNow, your URL looks as below:
You can specify the full URL as an instance or use only the instance name (in the example above - myinstance).
- In the Сlient ID field enter Client Id from Application Registry created in ServiceNow.
You can see this value while the Register Timeline in ServiceNow step.
- In the Client secret field enter Client Secret from Application Registry created in ServiceNow.
You can see this value while the Register Timeline in ServiceNow step. Click the lock button near Client Secret in ServiceNow to see its value.
- Optionally, filter which records to import.
- Load records for the last: X days/months
Specify the number of days or months.
This allows you to upload table records that match the specified time period, which is calculated according to the current date.
- Load records from selected time range
Specify the start and the end date.
This allows you to upload table records that have timestamps of the specified time range.
- Max number of imported records per table
Enter the number.
This allows you to set the number of rows of each table that will be imported.
Note. For trial or testing purposes, it is recommended to set it to 1000.
- Use time index on audit table
Select this option to optimize and speed up queries that pull data from ServiceNow.
Important. To use this option, the sys_audit table must have an index in the sys_created_on field. In case you select this option but the upload process slowed down, check that the required field has an index. For details, see Troubleshooting.
- Click Import.
- You will be asked to authenticate your access to the ServiceNow account. Enter its credentials and click Log in.
Important. Your ServiceNow account must have admin rights. For details, see ServiceNow > Before you begin.
- Click Allow to set Timeline connection to ServiceNow.
The import starts. It may take some time to upload and process data. After the import finishes, the project with uploaded timelines opens automatically. To learn more about generated timelines from the ServiceNow tables, see Imported Data from ServiceNow.
How to reconfigure the ServiceNow connection
If needed, you can change settings of the ServiceNow connection. Open Project details > Data sources and click Configure import under the ServiceNow option. Click to edit fields, select additional options, and set up import filters.
You can upload data from ServiceNow on a scheduled basis.
Note. If you plan to schedule data import, it is recommended to make sure that only new data will be uploaded. Set filters that will choose records to import. For example, if you upload data once a day, filter records using the option Load records for the last: 1 Day.
To schedule the data upload:
- Open Project details > Data sources and select Scheduled import under the ServiceNow option.
Note. This option is available after you configure a connection to ServiceNow in Timeline.
- Click to set the schedule.
- Specify Recurrence.
Choose the frequency of data import.
Note. You can change Time manually, for example, type 3:45 PM. Enter Time in UTC+00:00 time zone.
Set start Time for the first scheduled import and time gaps between the next uploads - every 1/2/3/6/12/24 hours.
Set Time for everyday data import.
Set Time and select Days of week from the drop-down list when to upload data.
Set Time and day of the month for the data import - First day of month, Last day of month or choose Day number and enter a date.
For example, it can be the 14th of every month at 12:30 AM UTC+00:00.
- Click Save.
To stop the scheduled import, unselect the Scheduled import option.
After you configure the schedule, the import task from ServiceNow appears in > Scheduled tasks.
5/25/2023 10:12:06 AM