Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Workflow custom assignment block

HarishG
Regular Contributor
Regular Contributor

Hi,

We have a usecase that when a role is modified, It should be approved by EntitlementOwner and EndpointOwner.

If anyone has come across such usecase, could you help me with the Custom Assignment block queries in WF?

 

Thanks,

Harish

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

Refer https://forums.saviynt.com/t5/identity-governance/route-role-request-to-entitlement-owner/m-p/70739#...

endpoint owner is which one role endpoint or entitlement under role ?


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

HarishG
Regular Contributor
Regular Contributor

Thanks @rushikeshvartak ,

endpoint owner of entitlements under the role

 

Regards,

Harish

Hi @HarishG ,

For entitlement owner:

 

SELECT eo.userkey FROM ars_requests ar left join request_access ra on ar.REQUESTKEY= ra.REQUESTKEY left join roles ro on ro.rolekey = ra.ACCESSKEY left join role_entitlements re on ro.ROLEKEY=re.ROLEKEY left join entitlement_values ev on re.ENTITLEMENT_VALUEKEY=ev.ENTITLEMENT_VALUEKEY left join entitlement_owners eo on eo.entitlement_valuekey=ev.ENTITLEMENT_VALUEKEY  WHERE ar.requestkey=${ARSREQUEST.id}

 

And for endpoint owner:

 

SELECT ep.ownerkey FROM ars_requests ar left join request_access ra on ar.REQUESTKEY= ra.REQUESTKEY left join roles ro on ro.rolekey = ra.ACCESSKEY left join role_entitlements re on ro.ROLEKEY=re.ROLEKEY left join entitlement_values ev on re.ENTITLEMENT_VALUEKEY=ev.ENTITLEMENT_VALUEKEY left join entitlement_owners eo on eo.entitlement_valuekey=ev.ENTITLEMENT_VALUEKEY left join entitlement_types ety on ety.ENTITLEMENTTYPEKEY=ev.ENTITLEMENTTYPEKEY left join ENDPOINTs ep on ep.ENDPOINTKEY=ety.ENDPOINTKEY where ar.requestkey=${ARSREQUEST.id}

 

If this helps your questions, please select Accept As Solution and hit Kudos