Database table name for groups creation via UI

[ronit]

Hi,

Could anybody please let me know the table/tables I could use to get the information the user submits while trying to create a group ( Okta or aad or adsi etc.. ) via UI which triggers a create entitlement pending task.

[Darshanjain]

As soon as the request gets processed, Roles are created with the entitlement name, so you can use the role and corresponding tables to get the details

[rushikeshvartak]

Before request approval :

Here 1421251 is request ID of Type Create Entitlement Request

SELECT rhcl.COMMENTS cmt,rhcl.CREATIONDATE,rhcl.FIELDNAME,rhcl.NEWVALUE,rhcl.OLDVALUE,rhcl.OPERATION,rhcl.ROLEHISTORYKEY,rhcl.ROLEKEY,rhcl.UPDATEUSER FROM roles_historychangelog rhcl, ars_requests ar, request_access ra WHERE ar.REQUESTKEY =ra.REQUESTKEY and rhcl.ROLEHISTORYKEY=ra.accesskey and ra.accesstype = 1 and ra.requesttype = 3 and SUBSTRING_INDEX(AR.JBPMPROCESSINSTANCEID,'.',-1)=1970260

once request is approved details will be found in arstasks table 

SELECT at.taskkey ,at.tasktype,rhcl.FIELDNAME,rhcl.NEWVALUE,SUBSTRING_INDEX(AR.JBPMPROCESSINSTANCEID,'.',-1) requestid FROM roles_historychangelog rhcl, ars_requests ar, request_access ra,arstasks at WHERE ar.REQUESTKEY =ra.REQUESTKEY and rhcl.ROLEHISTORYKEY=ra.accesskey and ra.accesstype = 1 and ra.requesttype = 3 and SUBSTRING_INDEX(AR.JBPMPROCESSINSTANCEID,'.',-1)=1970260 and at.requestkey=ra.requestkey and at.tasktype=24

Once tasks has been completed you can find role in roles table

select role_name,roletype from roles where roletype=6