Get the Activity Log of an Incident

[xantor]

Good day folk,

I've created a custom printing form for my Incidents that prints out everything as I want it to be. I only have one problem though...

I cannot seem to get the activity of a specific incident!

I keep getting "unspecified". Where is the Activity Log for Incidents stored? And how is it referenced to an Incident?

I'd like to get the Activity Log in String or HTML format doesn't matter which.

Any help would be great!

[Janel2]

Were you able to figure out any creative way to get the system information from the activity log?

I'm running into the same problem with the full activity log where any "system" values (like when a field changes values) don't appear in the default PDF export.   I found out it is apparently split between several different tables; sys_audit, sys_history, and sys_history_line.

sys_history_line will give you most of the history, but ServiceNow told me that the history can get mixed up between four sys_history_set tables since they rotate content for some reason (don't remember the reason, but it kind of made sense).