Questions about Activity Log and Audit Table Migration in ServiceNow

Risinkou1
Tera Contributor

‎10-28-2024 01:44 AM

The activity log information includes comments, notes, field modification history, and email sending history. I am trying to migrate an incident record, including the activity log, from Instance A to Instance B.

Step 1: When I export the incident record from Instance A in XML format and import it into Instance B, it seems that the journal entry information (sys_journal_field) is included in the XML file, which means that the notes and comments are also migrated together.

Risinkou1_2-1730104668466.png

Risinkou1_1-1730104642551.png

Question 1: While the comment and notes information has been reflected, there is an issue with the sorting order (display time).

Step 2: In Step 1, since the activity log did not include modification history information, I also imported the system audit table (sys_audit) information from Instance A into Instance B.

Risinkou1_4-1730104815546.png

 

As shown in the attached image, when I check the record details, I find that the modification history information is not displayed.

However, when I enter and submit any comment or notes information, I notice that the activity log content gets updated, and the modification history is displayed.

Risinkou1_3-1730104802421.png

 

Question 2: After migrating the audit table (sys_audit), is there a way to display the modification history without entering any comment or notes information? If you know, please let me know.
Question 3: I believe that the email sending history is also displayed in the activity log. Which table should I migrate the sending history data from?

I appreciate any guidance you can provide!

0 Helpfuls
  • 550 Views
1 REPLY 1

Risinkou1
Tera Contributor

‎10-30-2024 05:58 PM

Hello everyone,

I wanted to provide an update regarding the issue I posted about earlier, and I'm happy to report that it has been resolved.

Summary of the Issue:

  • I encountered a situation where the history set and history were not displayed when opening the main record.
  • I learned that the history set and history are automatically rebuilt based on the audit and journal entry information.
  • I realized that I opened the main record at an inappropriate time, and I should have imported all audit information before accessing it.


    My Questions:
  • For the email sending history, I am still looking for information on which table to migrate that data from and would appreciate any guidance.

Thank you all for your support!

0 Helpfuls