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]

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

[mvanderlist_spl · Accepted solution]

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?

[jkat54]

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