How to pull GRC Approver information into IDM for reporting purpose

[former_member298408]

We have a requirement to build a report in IDM which shows who all has approved a particular role assignment request in IDM and GRC.

I have prepared a report using table idmv_linkaudit_ext to pull details of who approved a particular role assignment request for a particular user in IDM, but I am not sure how to pull the information of who approved same role assignment request for same user in GRC.

Is there any table, or means by which I can pull/see this information in IDM.

Thanks!

[normann]

Hi Aditi,

the only way to get that information from AC into IdM is calling a web service in AC after the request got approved and add that information into the mxi_linkaudit table.

http(s)://<AC_HOST>:<AC_HTTP(S)_PORT>/sap/bc/srt/rfc/sap/grac_audit_logs_ws/<AC_CLIENT>/grac_audit_logs_ws/grac_audit_logs_ws

I have done this already, its little complex to parse the xml but its possible.

Regards

Norman