KNOWLEDGE BASE

Date Range Prompted When Connecting To Servicenow ITSM


Published: 31 May 2020
Last Modified Date: 02 Jun 2020

Question

The date range selection is prompted when connecting to ServiceNow ITSM. What field is used to filter the date range in the ServiceNow ITSM?

User-added image

User-added image

Environment

  • Tableau Desktop
  • Windows
  • ServiceNow ITSM

Answer

The column used to filter the date range in service now is sys_updated_on which is the timestamp of the last update to the record. However, this column is in the Table Columns embedded list and not visible to end-users. sys_updated_on is added automatically for all ServiceNow tables and it can not be manually deleted or modified by end-users.

Please refer to https://docs.servicenow.com/bundle/newyork-platform-administration/page/build/applications/reference/r_GlobalDefaultFields.html

User-added image

The date range filter specified when connecting to ServiceNow DS is saved in Tableau. When clicking the specified table in Tableau Desktop, it will apply the filter and assemble the REST API URL using sys_update_on to specify the date range, which is complying with ServiceNow Rest API convention.

For example, when you specify the date range as a fixed one: 2018-01-01 to 2019-12-28 and click the table problem, the following URL will be sent to ServiceNow ITSM.
https://xxxxx.service-now.com/api/now/v1/table/problem?sysparm_query=sys_updated_on%3E=2018-01-01%5Esys_updated_on%3C2019-12-28%5EORDERBYsys_created_on&sysparm_fields=&sysparm_limit=500&sysparm_offset=0 

 

Did this article resolve the issue?