Volume of Access Requests not completed due to rejection by line manager or application owner

[AshirvadhN]

Hi Team,

Any of you worked on these kind of reports. if done please help me also.

1. Volume of Access Requests not completed due to rejection by line manager or application owner

we need to generate a report for the access requests(Add access, New account, remove account, update account) which are not completed due to rejection by line manager or application owner.

please help me in this.

[sk]

you can use below tables to build your logic

1. ars_requests
2. request_access
3. access_approvers

access_approvers table is where it holds whether request is approved or rejected under status column and JBPM_ACTIVITY_NAME column is what it decides who is the approver

[AshirvadhN]

If you have created the report. Please can you share it.