on 02-26-2015 6:00 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Madhu
Field UPDATED_ON shows the last time the Request was updated which was Provisioned.
I still cannot find when the Manager approved the Request.
For e.g. Request was created on 10th, Manager approved on the 12th and Security Approved on 15th and Roles were Provisioned on 15th. Then the table shows Updated on15th. I'm looking for when the Manager approved the Request, in this e.g. 12th.
Is there another table for this?
Regards
Mustafa
Hi Mustafa,
Then you need to check these tables:
GRFNMWRTINST - Give ReqNo in EXTERNAL_KEY_DIS and get INSTANCE_ID
GRFNMWDATLG - Give Instance Id in this table to get details. In this table based on Stage execution sequence column and LineItem status you can determine when it was approved/rejected.
Basically you need make use of all the tables join them, Vlookup etc as suggested and determine what you wanted to achieve as all data is not available directly in one table
Regards,
Madhu.
Thanks Madhu
Im aware that there is no single table that provides all the information
I have tried several tables in that ast as well by joining them.
From the one you have given GRFNMWDATLG might be the answer for me.
Only problem is that when I execute this table I get error "Table GRFNMWDATLG is not active in the Dictionary"
Can you help with this?
Regards
Mustafa
Hi Madhu
I have spoken to our Basis Team and unfortunately this table does not exist.
Get message "GRFNMWDATLG does not exist. Check name"
Even if we had to create it, it will be empty.
Apparently its not availabe on the version im on. I need to upgrade. Is this correct?
We on GRC 10. SP10.
Is there another table or another way?
Regards
Mustafa
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mustafa,
you can use Search Request to get the approved requests.
Regards,
Alessandro
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.