We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Generate remove access task along with remove account via analytics

NM
Regular Contributor II
Regular Contributor II

We have requirement to create dependent remove access task once remove account/deprovision account task is generated via analytics.

Possible solutions on how we can achieve the above scenario (Action to be performed via job)?

2 REPLIES 2

prasannta
Saviynt Employee
Saviynt Employee

Hi @NM 

You can create an actionable analytics to fetch all entitlement associated with the accounts and trigger deprovision access for those entitlements.

Please refer below documentation:

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter17-EIC-Analytics/Managing-An...

Thanks

rushikeshvartak
All-Star
All-Star

You can use below sample query 

SELECT ae1.entitlement_valuekey AS entvaluekey,
       ev.entitlement_value,
       ae1.accountkey           AS acctKey,
       a.NAME,
       'Deprovision Access'     AS 'Default_Action_For_Analytics'
FROM   account_entitlements1 ae1,
       accounts a,
       entitlement_values ev
WHERE  a.accountkey = ae1.accountkey
       AND ev.entitlement_valuekey = ae1.entitlement_valuekey
       AND a.endpointkey = 12
UNION
SELECT ''                   AS entvaluekey,
       ''                   AS ENTITLEMENT_VALUE,
       a.accountkey         AS acctKey,
       a.NAME,
       'deprovisionAccount' AS Default_Action_For_Analytics
FROM   accounts a; 

 

Documentation :https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter17-EIC-Analytics/Managing-An... 


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