unable to update history table(sys_history_line)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-22-2018 05:51 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-22-2018 05:55 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-22-2018 06:13 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-22-2018 06:21 AM
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.