what is sys_history_line will contain?

[sreenivassinsta]

what is the purpose of sys_history_line

[Harsh Vardhan]

The History [sys_history_line] table stores the actual changes to field values that occurred. The system automatically generates History Set and History records as needed from the Audit table when a user either creates a record or requests its history. Rather than containing a complete history of all changes in the system, History Set and History records only contain a recent subset of historical information for records where users have created or requested such information.

The system limits History Set and History records by:

• Having the table cleaner delete History Set records that have not been updated in 30 days.
• Using table rotation to rotate between four History tables every seven days. This means the system drops History records that are older than 28 days.

Should someone need historical information again at a later date, the system can regenerate it from auditing source records.

refer the thread below.

https://community.servicenow.com/community?id=community_question&sys_id=e7344b29dbd8dbc01dcaf3231f96...

[nitin_kumar]

Hi Sreenivas,

The History [sys_history_line] table stores the changes to records when the audit is turned on the table. Please look into the following links for more understanding

History Sets

Differences between Sys Audit and History tables

Community Post

Thanks,

Nitin.

Please set this answer as correct or helpful based on the impact

[Priyanka136]

Hi sreenivassinstance,  

I am providing the link, which will help you for better understanding. 

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/administer/security/reference/r_HistoryList.html

Mark it Correct If it helps to you.

Warm Regards,

Priyanka kumbhare

|www.DxSherpa.com|

[Akash4]

Hi Sreenivas apart from the above replied I would like to show the actual fields you can read off.

Regards,

Akash