XML data extract

[shohebshaikh]

Hi,

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

[Chuck Tomasi · Accepted solution]

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

[shohebshaikh]

I got he list but it is taking too much time to load and most of the times the script gets cancelled

[Chuck Tomasi]

You will have to break it down in to smaller chunks. sys_audit can be a very large table with a lot of records. It's very uncommon for people to export/import that table.

[shohebshaikh]

Thanks for the reply Chuck.

As our is a shared instance and the data contains millions of entires. I cannot find domain specific data. Is there a way where I can filter data based on domain, that would be really helpfull fo export data.