on 12-16-2014 3:30 AM
Dear GRC Experts,
I need a report showing the audit trail for the
users, who approved, what roles assigned, etc in the access requests.
I could not find these reports for large number of users.
Can you advise the best way for me to get
that?
Regards,
Sindhu
Hi Sindhu,
You can pull the data by using GRC tables GRACREQ and GRACREQPROVLOG
Regards,
Madhu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Madhu,
Thank you very much for response and the solution.
I have read couple of your blogs and its really helpful and informative which has resolved some of my GRC issues .
Let me check the tables, do we have any available audit reports in NWBC for the access requests, i could not find one?
Regards,
Sindhu
Hi Sindhu,
In NWBC there is no detailed report as such but you can make use of these tables and can pull the report.
GRACREQ
GRACREQOWNER - This will give Creator, Manager and Requestor details. If your role owner is standard role owner agent then you can gets the details from table GRACROLEAPPRVR using the role names from GRACREQPROVLOG
GRACREQPROVLOG
Finding current approvers, etc will depend on what you MSMP Agent definitions are, etc. You might find it easier to trace the access request in ST05/STAUTHTRACE and look at the SQL statements, or look at the MSMP Instance Runtime report and leverage the code
Regards,
Madhu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.