topic How can I validate that new tables exist and contain the right data prior to adding them into the Splunk Add-on for ServiceNow? in All Apps and Add-ons

How can I validate that new tables exist and contain the right data prior to adding them into the Splunk Add-on for ServiceNow?

mvanderlist_spl — Mon, 18 Jan 2016 17:02:58 GMT

How can I validate that new tables exist, and contain the right data prior to adding them into the ServiceNow Add-On?

Re: How can I validate that new tables exist and contain the right data prior to adding them into the Splunk Add-on for ServiceNow?

mvanderlist_spl — Tue, 29 Sep 2020 08:24:02 GMT

If you want to bring in a new service now table (i.e. task or u_custom_table, etc), you can validate this table exists through the command line:

curl -H "Accept:application/json"  'https://[username]:[password]@[instance].service-now.com/api/now/table/[table_name]?sysparm_limit=1'

Replacing username, password and instance with valid login credentials, and table_name with the table your are looking for.

In the resulting table, you will want to validate you see the sys_created_on or sys_update_on fields, or whatever rising column field you want to use.

{"result":[{"description":"",...,"sys_updated_on":"2015-08-14 20:10:55",...,"sys_created_on":"2015-08-10 19:39:09",...}]}

You can usually find your table name in the URL of service now:

https://[instance].service-now.com/[table_name].do?

Re: How can I validate that new tables exist and contain the right data prior to adding them into the Splunk Add-on for ServiceNow?

jkat54 — Mon, 18 Jan 2016 17:31:33 GMT

What tables are available in ServiceNow?

http://wiki.servicenow.com/index.php?title=Tables_and_Classes

How can I validate that new tables exist, and contain the right data prior to adding them into ServiceNow Add-on?

http://wiki.servicenow.com/index.php?title=Category:Table_Administration <- bookmark this

but to answer the question, this:

http://wiki.servicenow.com/index.php?title=Creating_a_Custom_Table