XML data extract

shohebshaikh · ‎08-12-2016

Hi,

How do I extract data of the 'sys_audit', 'sys_choice', and 'sys_attachment' table for Incident table.

Chuck Tomasi · ‎08-12-2016

Hi Shoheb,

All three tables have a table field on them. You can simply filter on that.

Use the navigator filter to go to sys_choice.list (or sys_attachment.list), filter on the correct value in the correct field, then right click Export> XML.

sys_audit is potentially very large and I don't recommend exporting it unless absolutely necessary. Often times, taking the history from one instance to another is not mandatory.

Exporting and Importing XML Files - ServiceNow Wiki

View solution in original post

Chuck Tomasi · ‎08-17-2016

When you look at this list filter, is there a Domain field option in the field picker? If so, use that to filter on the domain. I don't have immediate access to a domain separated instance so I cannot verify if this table is domain separated or not.

shohebshaikh · ‎08-17-2016

Hi Chuck,

There is no Domain field option in the filter.

Chuck Tomasi · ‎08-17-2016

Without a domain field, there's no way to get just the audit records for a particular domain then.

Forgive me if I've already asked... what is the business requirement behind extracting information from a single domain from the sys_audit table?

shohebshaikh · ‎08-17-2016

It is just the reqirement which we got. We dont knw the reason behind it.

Chuck Tomasi · ‎08-17-2016

Thank you Shoheb. Unfortunately, you won't be able to meet this particular requirement.