How to extract Audit log for an incident or task from ServiceNow?

Praveen_Prabhak · ‎07-03-2018

I am trying to extract the Audit Log(Incident lifecycle) data for Incidents and Tasks, Please help me with your ideas. Is there a pre-defined table in SNOW through which this can be obtained?

Attached screenshot shows Audit log of an incident from Remedy.

Karishma5 · ‎07-03-2018

Hi Praveen,

Auditing information is kept in these tables:

The Audit table. [sys_audit]
The History set table. [sys_history_set]

For further information you can refer to the following link:

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/security/concept/...

Hope it helps. Mark it as helpful or correct if find helpful.

Regards,

Karishma Horo

www.dxsherpa.com

Praveen_Prabhak · ‎07-04-2018

Thanks, Karishma! I will give it a try and keep you posted!!

Manas Kandekar · ‎09-05-2019

Hi Praveen,

Configure - > Related list

add 'Audit history' then right click on History -> Open in new window. From there you can export to excel.