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

SanjivMeher
Kilo Patron
Kilo Patron

sys_audit and sys_history_line


Please mark this response as correct or helpful if it assisted you with your question.

Sanjay Bagri1
Tera Guru

Hi , 

 all kind of information are stored in task.list table  like short_description ,priority, assigned_to and state etc .

so you can check those fields in task table .

all tables(Like Incident, problem ,change ettc.)  of record will be available in task table.

please remeber it mark as correct and helpful .

Thanks 

Sanjay Bagri

MMKK
Tera Expert

I hope you did not understand my question.

for example, i change priority of a task. it is captured in activity log. 

It says Priotiry was low now high with some time stamp. Then I change that back to medium.

Again, it is stored in activity log with timestamp. What tables has this information is my question

Hi, 1) Journal entries are captured in sys_journal_field 2) History activity are captured in various tables like: sys_history_set sys_history_line Please mark answer as correct, if it was really helpful 🙂
If my response helped please mark it correct and close the thread.

Thanks,
Rahul Kumar