Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/26/2022 05:17 AM
08/26/2022 05:31 AM - edited 08/26/2022 05:38 AM
What does automation rule mean by Technical Rule /User Update Rule ?
select distinct u.username,u.title ,u.JOBCODE,u.employeetype,ae1.accountkey,ev.entitlement_value,ASSIGNEDFROMRULE
from account_entitlements1 ae1,entitlement_values ev ,user_Accounts ua ,users u
where ev.entitlement_valuekey=ae1.entitlement_valuekey and ua.accountkey=ae1.accountkey and u.userkey=ua.userkey
08/26/2022 05:35 AM
Technical Rule.
08/26/2022 06:52 AM - edited 08/26/2022 06:58 AM
Are you saying you want the details of the users along with their entitlements for access provided via a technicla rule ?
If Yes, then you could refere to the link below for the schema guide.
Once you have the user, accounts,entitlements details, you can use the ASSIGNEDFROMRULE from account_entitlements1 table as @rushikeshvartak has suggested. However, the output of this query might run into hundreds and thousands so you need to be careful when you run this in your Prod environment.