Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
  • 701 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