which table shows the task field changes in activity

MMKK
Tera Expert

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

1 ACCEPTED SOLUTION

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

View solution in original post

8 REPLIES 8

Did you check sys_audit and sys_history_line?

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

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

 

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

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