How do you export audit history?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2019 12:47 PM
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2019 01:47 PM
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.
Regards,
Sachin