Table responsible for storing contents in 'Activity Log'?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-30-2014 04:07 AM
Which 'Table' in Service-Now tool is responsible for capturing the details like notifications,worknotes,comments etc in 'Activity Log' for a form?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-30-2014 04:52 AM
Hi Maheswara Reddy,
That is stored in "sys_audit" table.
Please let me know if you have any questions.
Thanks,
Pradeep Sharma
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-30-2014 10:20 AM
Remember!! The best way to tank the performance of your system is to report off those tables. Would it be rude to ask why you need to know what tables they're in?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-03-2014 04:58 AM
All we want to do is copy the entire details available in activity log to new record.So far we were able to carry forward the data that is available in work_notes,comments (stored in journal table).
Regards,
mahesh.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-22-2016 02:32 PM
Hi Maheswara, I have been trying to implement the same feature to copy the data in the journal fields. Can you share with me how you accomplished this task?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-17-2021 02:03 PM
Hi Robert,
What is the safest manner in obtaining changes on the following via REST Api calls:
- incident.assignment_group
- incident.assigned_to
Calling the REST endpoing /api/now/table/sys_audit with tablename, columname, sys_created_on filters is problematic for many reasons.
What alternatives exist for obtaining value changes for these columns?
Thanks,
George