How can i extract report from Sys Audit table along with the Incident records(not the sys id's).

[Jayant Balyan1]

I want to extract report from Sys audit table and compare it with the changes made on Incidents. Sys audit table has sys id for those incidents. How can i extract file/report with the Incident numbers.

Thanks.

[Sulabh Garg]

Hello Jayant,

There is no easy way to do this. 

First you have to extract (export) the records from sys_audit table and then you need to take all the sys_id's extracted and find the corresponding Incident number. You can do this by creating the database view on Incident table and create a report on it and then apply the condition on report (sys id is one of <enter all sys_id's> ) then you will be able to find the sys id and corresponding incident number and then export the report.  (you cannot find the Incident number and sys_id from list view of Incidents as sys_id will not come after export).

And then apply the vlookup on your first extracted report and then you can find the corresponding Incident number with sys_id.

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

[Jayant Balyan1]

Thanks Sulabh.

[Sulabh Garg]

Thanks Jayant for marked my response as correct, Prefer not to create database view on "sys_audit" table as it will result into performance issues.

[Jaspal Singh]

@Sulabh Garg  no need to do a vlookup. Database view in ServiceNow itself will suffice the need.

[Sulabh Garg]

Yes, But I don't prefer to create a database view on sys_audit table for obvious reasons. In my approach database view can only be created on Incident table to get the sys_id's.