unable to update history table(sys_history_line)

[Maniraj Jayaraj]

We are in a situation where we need to update the history table(sys_history_line), but unable to do so. We tried from both background script and form level even after i modified the existing ACL it doesn't seem to be working. Any suggestion how to update in history table?

[Kalaiarasan Pus]

This is a bad idea and will not work. First understand the difference between audit and history tables.

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/security/concept/c_DiffBtwnAuditHistSets.html

This information in history table is not permanent and hence doing any changes to the data has no use.

[Maniraj Jayaraj]

Hi Kalai,

Thanks for your reply.

I am well aware that history line  records directly refers to audit record rather than actual record. i ll explain our situation detail...

We have migrated data from a MSP instance to a dedicated instance, but we didn't use XML instead we used CSV/Excel since we required lot of customizations in the dedicated instance.

Now all the records are re-created with differet sys_id's, but we need to load all audit of all existing records to the new instance which are having different sys_id.

so we tried exporting all audit records(sys_audit,sys_history_set,sys_history_line) as xml and try running scripts to update the newer record sys_ids

but we were unable to do that in sys_history line table, which we needs to be done to retain all audit records.

Thanks,

Maniraj

[Kalaiarasan Pus]

I do not think that you have read the link and understood that the data in the table is rotated and temporary. I would ask you again to read the link.