Access Provisioning through analytics

[GoutamAhirwar]

Hello,

We have task to provisioning entitlements to the accounts for specific endpoint through analytics query i used different method to do it but unable to find solution. 

can you   guide me  on how to solve this.

[armaanzahir]

@GoutamAhirwar 

Please refer the following documentation and model the query along the sample provided below:

select ev.entitlement_valuekey as entvaluekey, a.accountkey as acctKey, a.name as accName,u.userKey from entitlement_values ev, entitlement_types et, accounts a, user_accounts uwhere ev.entitlementtypekey=et.entitlementtypekey and et.endpointkey=6 and a.accountkey in(select accountkey from accounts where endpointkey=6) and u.ACCOUNTKEY=a.ACCOUNTKEY;

Configuring Allowed Actions (saviyntcloud.com)

[GoutamAhirwar]

Thanks for your concern But my case is different i want provision entitlement to accounts with the use of analytics query eg. 

case when u1.STATUSKEY=1 then 'Active' when u1.STATUSKEY=0 then 'Inactive' end as UserStatus,

u4.NAME,u5.ENDPOINTNAME,u6.ENTITLEMENTNAME,u7.ENTITLEMENT_VALUE,

'Provision Access' as Default_Action_For_Analytics,

 Just like this format

[rushikeshvartak]

Please share current query.

please refer documentation 

https://docs.saviyntcloud.com/auth/login/?redirect=%2Fbundle%2FEIC-Admin-v23x%2Fpage%2FContent%2FCha...

[dgandhi]

This can be achieved using Actionable analytics.

Make sure you have below fields in your analytics query

entvaluekey - Entitlement value key of the entitlement to which the account will be assigned.
acctKey - Accountkey of the account to provision with the entitlement.
accName - Name of the account to provision with the entitlement.
userKey - Userkey of the user to whom the account is mapped.

[Manu269]

@GoutamAhirwar check out this sample provided here :

Provisioning or deprovisioning assignments from SAV Role via Analytics (saviyntcloud.com)