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

shohebshaikh · ‎08-17-2016

Ok no issues. Thanks again Chuck for your help as always

Chuck Tomasi · ‎08-17-2016

I know it's not the answer you were looking for, but it IS an answer. Please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button. If so, please review How to Mark Answers Correct From Inbox View.

Thank you