Skip to Content
avatar image
Former Member

How to check Approved GRC Access Requests

Hi Experts

I need to know how many access requests were approved in a month.

Is there a report I can Run or use Search Request? Or do i need to create a Query with different tables?

Urgent assistance would be appreciated.

Regards

Mustafa

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 26, 2015 at 12:18 PM

    Hi Mustafa,

    Please Join below tables to get the complete report with Request Number, Request Type, Prov Items, Approval Status and Approver Details.

    GRACREQ - Get Request Number

    GRFNMWRTINST - Give ReqNo in EXTERNAL_KEY_DIS and get INSTANCE_ID

    GRFNMWDATLG - Give Instance Id in this table to get details

    To get Provisioning Item details use tables GRACREQPROVITEM and GRACREQPROVLOG

    Regards,

    Madhu.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Madhu,

      Thanks.

      I can find the req no and role name with Approval status using these two tables GRACREQPROVITEM and GRACREQPROVLOG but how to find out who is the approver for that role in the request .

      can we have any table to find the all these details.

      Thanks,

      Bhagya

  • Feb 26, 2015 at 09:09 AM

    Hi Mustafa,

    you can use Search Request to get the approved requests.

    Regards,

    Alessandro

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Alessandro

      Search Request does not give you many were approved in a day or month.

      It only shows Approved.

      Regards

      Mustafa

  • Sep 14, 2016 at 10:56 AM

    Hi Mustafa,

    Kindly refer to the dashboard report "Access Request" in the tab Reports and Analytics. This report displays the information in the form of bar chart.

    Do let me know if it helps.

    Thanks & Regards
    Japneet

    Add comment
    10|10000 characters needed characters exceeded