Request History of a specific record to display in History line table to find a specific update.

[Madhav Rao D V]

The history [sys_history_line] table stores actual changes to field values. The History [sys_history_line] table does not currently have the history of old records. Is there any way to request from Audit [sys_audit] table keep history in the history[sys_history_line] table. The requirement is to find a specific change that is happened on the old records.??

[fmelard]

Well this is using the table rotation for performances considerations:

https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/platform-performance...

You may query the sys_audit table carefully (this is not recommended - try first on a PDI with few data by narrowing the search to its maximum with precise query terms), or you may face performances issue by querying such a big table.

sys_history_line is here to buffer the information recently consulted by the users.