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.

[Jaspal Singh · Accepted solution]

You need to create a Database view for 

sys_audit & incident table. 

Once done you can report on number instead of Document key.

Can you one such need as it is not ideal to report on audit & other tables not because of security but tons of data it holds.

[Jayant Balyan1]

Thanks Jaspal.

[Jaspal Singh]

@Jayant Balyan  I see you marked both answers correct but unfortunately per thread only one answer can be correct.

Suggest you to mark the suitable one that helped with minimal efforts.

[Thomas G]

I have a quite similar requirement. I need to report on incidents assigned or re-assigned to a specific person from three specific Assignment Groups. Each time the incident is assigned og re-assigned to a person from the three Assignment Groups, the report must show the date and time for when that happened, and who the assigned to user is.

I have created a database view like mentioned in this thread based on the sys_audit and the incident table with 'inc.sys_id=adt.documentkey' in 'Where clause' for the incident table. A report is then build based on this database view. My problem is how to make the report show only assignments and re-assignments. Right now it seems to show every field update from the sys_audit table instead of just field updates on the assigned_to field. How can I achieve that?

Best regards
Thomas