Activities (Filtered) Field

[rsanon]

The Activities (Filtered) Field on an Incident form, that shows where changes were made to the record. Where is the information captured? Can I run a report on the field?

[brad_hicks]

The information is stored in one and in some cases all of the following tables:

• sys_audit
• sys_history_set
• sys_history_line

As far as running a report on the field, this is where it gets complicated.   Due to the amount of data that is typically being stored at any given time within these tables it isn't recommended that you use any of these tables for reporting purposes.   If you do not have a choice then I would look at the data in the sys_history_set table and then find the record that I'm interested in.   Once you open the sys_history_set record you will then find the various lines (sys_history_line) that are involved with the many updates to that particular record.   Here's the wiki article that outlines this quite well - Viewing History Sets - ServiceNow Wiki.

[Chinthuja2]

Hi Brad,

Is it possible to add activity trail in any custom tables?

[Mike Allen]

Just personalize the form and add Activities(filtered) to your form.   If it is not there, here are the instructions on how to create it:

Activity Formatter - ServiceNow Wiki

[Chinthuja2]

Thank you Mike! My bad! I followed the instructions but was checking the Layout at List level instead of Form level