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

Jayant Balyan1 · ‎05-17-2022

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 · ‎05-17-2022

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.

View solution in original post

Sulabh Garg · ‎05-18-2022

Yes, These two options are also there to extract the sys id's along with the database view one.

Please Mark ✅ Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg

Jayant Balyan1 · ‎05-18-2022

Thank you very much @Jaspal Singh and @Sulabh Garg for your valuable suggestions. I will surely try them.

Best regards,

Jayant