We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

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
Mega 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