Why Are Recent Updates Missing From the SYS_HISTORY_LINE Table?

Question

Why are some recent updates missing from the SYS_HISTORY_LINE table?

Environment

Connector: ServiceNow

Answer

The ServiceNow SYS_HISTORY_LINE and SYS_HISTORY_SET tables do not store a complete history of all record changes. ServiceNow only creates history records only after a record's history is requested, such as when a user views the record’s history in the ServiceNow UI. If no one has viewed a record's history, these tables may not include its recent changes.

For a complete audit trail, contact the ServiceNow support team to confirm the right source table for the historical data you need.

For more information, see the ServiceNow documentation on the difference between audit and history sets.