which table shows the task field changes in activity

[MMKK]

In the activity log, I see that information of field changes such as "assigned_to" is captured. Which table stores this type of information?

[SanjivMeher]

Did you check sys_audit and sys_history_line?

It stores these changes in old and new value column and identifier is ticket sysid

[MMKK]

Which columns should I refer for the sys_id of the record in these tables.

[SanjivMeher]

In sys_history_line table, audit sysid and in sys_audit table, document id.

[vinothkumar · Accepted solution]

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/time/concept/audited-tables-2.html