Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Database table name for groups creation via UI

ronit
New Contributor
New Contributor

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.

2 REPLIES 2

Darshanjain
Saviynt Employee
Saviynt Employee

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
All-Star
All-Star

 

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

rushikeshvartak_0-1661196203671.png

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

rushikeshvartak_1-1661196788092.png

 

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

select role_name,roletype from roles where roletype=6


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.