Report to extract actions of Automation rule

[SanthoshAradhya]

Hi  Everyone,

We are trying to pull data in Saviynt with details like title, department, employee type code and entitlements assigned by automation rule. Can you provide assistance/query/ report to pull this data.

Thank You

[rushikeshvartak]

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

[SanthoshAradhya]

Technical Rule.

[avinashchhetri]

@SanthoshAradhya,

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.

https://saviynt.freshdesk.com/support/solutions/articles/43000521404-saviynt-enterprise-identity-clo...

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.