How to remove an entry from Activity log?

[antonymirza]

How to remove an entry from Activity log?

[antonymirza]

Hi Salva,

Finally, I got the solution therefore, would like to share with you as well.

In addition to sys_audit, there is one more table sys_history_set which tracks audited record's history.

Though, Audit [sys_audit] captures the history of audited record's but after Aspen release ServiceNow doesn't support it and use History Sets [sys_history_set] to capture the same data.

Therefore, if we remove an entry from History Set table, that will remove corresponding values from Activity field in Incident/Problem/Change record.

I tried and it worked also.

Thank you for all your support and valuable inputs.

[Slava Savitsky]

You are right. In fact, history sets are created based on data stored in sys_audit table. If you delete a history set, it will be rebuilt using actual data from sys_audit.

[Mark Stanger]

I just created a much simpler way to do this and posted the solution at ServiceNowGuru. Hit the link for details...

http://www.servicenowguru.com/system-definition/remove-activity-log-journal-entries/