Which table has activity data?

[Koji Yanase]

Activity shows both newly inserted data and updated data. How does ServiceNow generate such activity record? Where does the data exist?

Thanks.

[Manjul Katare]

Hi Koji,

I guess activity is built using "Logs" and "system preferences".

This link should help you a little bit : Re: Where is the users activity filter stored?

-Manjul

[Abdul Khan4 · Accepted solution]

Activity is stored in sys_history_line TABLE.

Please read this post How can I add the user ID to the activity log stamp in a record?   for more details.

[Marcelo Cruz]

Great! Thanks!

[Pradeep Sharma]

Hi Koji,

Please go through the below wiki link for more info.

http://wiki.servicenow.com/index.php?title=Turning_on_Auditing_(History)_for_a_Table