How do you export audit history?

e_wilber
Tera Guru

I am trying to follow the SN documentation on https://community.servicenow.com/community?id=community_article&sys_id=215d6629dbd0dbc01dcaf3231f961... where you build the original export of records (which we're exporting Incidents and importing them as Cases).

That part works good and we have a field "Originating Incident" so we can track which incident generated the case.

What doesn't make sense is how you get the sys_audit history file created so it can be imported. We aren't converting all of our incidents, just half of them, so we can't just do a dump of all the incident data on the audit table.

If I have a list of incident numbers, how do I determine which records in sys_audit I need to export to bring this data over?

1 REPLY 1

sachin_namjoshi
Kilo Patron
Kilo Patron

It's not good idea to export audit records since audit tables are very huge in size and it may cause performance issues.

Instead, you should configure metric definition to report on field values changes for records.

 

https://docs.servicenow.com/bundle/geneva-performance-analytics-and-reporting/page/use/advanced_repo...

 

Regards,

Sachin