Table responsible for storing contents in 'Activity Log'?

roshan_saji
Kilo Explorer

Which 'Table' in Service-Now tool is responsible for capturing the details like notifications,worknotes,comments etc in 'Activity Log' for a form?

10 REPLIES 10

Hi Maheswara Reddy,



That is stored in "sys_audit" table.


Please let me know if you have any questions.



Thanks,


Pradeep Sharma


Uncle Rob
Kilo Patron

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?


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.


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!


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