Audit Report of user activity like CURD operations on Request & Requested Item table

ASWIN EPARI2
Tera Contributor

‎08-08-2023 01:31 PM

I have a requirement to list all user activity ( more of a scheduled weekly report) like read / write / delete actions on REQ & RITM tables. Please advise.

0 Helpfuls
  • 333 Views
2 REPLIES 2

Tushar
Kilo Sage
Kilo Sage

‎08-08-2023 05:42 PM - edited ‎08-08-2023 05:42 PM

Hi @ASWIN EPARI2 

 

First, ensure that the audit logging is enabled for the tables sc_request and sc_req_item.

Than i believe you can try reporting on sys_audit table.

 

 

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Regards,
Tushar

0 Helpfuls

ASWIN EPARI2
Tera Contributor
In response to Tushar

‎08-09-2023 05:41 AM

1st - lot of posts dont recommend reporting on sys_audit table

2nd - I need audit for read operations too, is that captured in sys_audit table ?

0 Helpfuls