User Update Rule based on Entitlement

[bhuvanesh]

Hello Saviynt Team,
 
We have a use case, where we want to send an email notification. if department changes and user is only part of particular AD group, Entitlement name like *SCP*. We tried with below update advance query, but getting invalid condition while previewing. Could you please help us, what i am doing wrong here.

(##a.departmentname isupdated##) and a.statuskey=1 and a.id in (select distinct us.userkey from User_accounts us, Accounts ac, Account_entitlements1 ae1, Entitlement_values ev where us.accountkey = ac.id and ac.id = ae1.accountkey and ae1.entitlement_valuekey = ev.id and ev.entitlement_value like "%SCP-%" and ac.status = 1 and ac.endpointkey = 12)

Thanks

[NM · Accepted solution]

a.statuskey=1 and a.id in (select distinct us.userkey from User_accounts us, Accounts ac, Account_entitlements1 ae1, Entitlement_values ev where us.accountkey = ac.id and ac.id = ae1.accountkey and ae1.entitlement_valuekey = ev.id and ev.entitlement_value like '%Entitlement value%' and ac.status = 1 and ac.endpointkey = endpoint key)

Preview gets hidden if you add "isupdated".

[navneetv · Accepted solution]

Hi @bhuvanesh query looks good but instead of (") you need to (') where you have defined the group name.  

[AmitM]

Hi @bhuvanesh , try this 

(##a.departmentname isupdated##) and a.statuskey=1 and a.id in (select distinct us.userkey from User_accounts us, Accounts ac, Account_entitlements1 ae1, Entitlement_values ev where us.accountkey = ac.id and ac.id = ae1.accountkey and ae1.entitlement_valuekey = ev.id and ev.entitlement_value like '%SCP-%' and ac.status = 1 and ac.endpointkey = 12)

It works for me 

Documentation : https://forums.saviynt.com/t5/saviynt-knowledge-base/advanced-usage-of-eic-identity-objects-in-provi...

- Amit