Migrating work notes and comments from one instance to another

jakehford
Kilo Contributor

We moved over our incidents from one table to another via XML exports/imports. However, not all of the activity logs are showing up, specifically activities created by "System"(Emails, etc.)

We researched and tried exporting/importing the following tables, but it did not change anything:

 

Sys_audit

Sys_history_line

Sys_history_set

Sys_journal_field

 

Anyone have an idea of how to get ALL the logs transferred over?

3 REPLIES 3

Allen Andreas
Administrator
Administrator

Well those are created by/stored by the system hence the prefix sys, but you could also do sys_email.

The others that you've done are fine. If you're still missing stuff after that, please be specific. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Hi,

I just wanted to follow-up and see if my solution helped resolve your issue.

If so, please mark as Correct and/or Helpful, if applicable.

Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

AmanG
ServiceNow Employee
ServiceNow Employee

You need to rebuild the history set once all the data is copied over.