How to transfer activity logs (Journal input) against record across instances

[georgechen]

Hi folks,

Anyone could advise a way to transfer a journal input (activity field) across instances?           I have tried to import records from sys_journal_field, and sys_history_line tables, however, not all the activities have seemed to transferred.

If you could advise, it would be appreciated.

Thanks,
George

[Pradeep Sharma · Accepted solution]

Hello George,

I think you need to pull the info from three tables i.e Audit [sys_audit], History Sets [sys_history_set], and History [sys_history_line] tables. Please refer below link for more info.

http://wiki.servicenow.com/index.php?title=History_Sets#gsc.tab=0

[georgechen]

Hello Pradeep,

Thanks for the prompt response.   I have looked at the three tables and tried to import the associated records into target instance,   the activity section looks much better, despite a minor missing of fields but I have raised with HI as target instance is in Prod for security concerns.

As always you are very much appreciated