Regarding User Update Rule

[sumagalla]

The below user update rule advanced query is not working as expected. Even though I have given a condition of accounttype as Primary, the task is getting triggered for the accounttype Secondary too, Could you please check and let me know what I have to correct in the query to trigger the task only for the Primary accounttype.

(##a.displayname isupdated##) and a.id in (select distinct us.userkey from User_accounts us, Accounts cc, Endpoints ep where us.accountkey=cc.id and cc.endpointkey =ep.id and ep.endpointname='AD' and cc.accounttype='Primary')

[NM]

Hi @sumagalla , is accountype populated in account.

Check the query in data analyzer does it give right results ??

[stalluri]

@sumagalla 
User regular queries and add accounttype at endpoint level. This will only pick Primary accounts.

or

(##a.displayname isupdated##) and a.id in (SELECT DISTINCT us.userkey FROM User_accounts us, Accounts ac WHERE us.accountkey = ac.accountkey AND ac.accounttype = 'Primary' AND ac.endpointkey=<XXXXXXXX>)

 

[rushikeshvartak]

Please share logs in text format
Could you kindly provide a detailed snapshot of the information extracted from the logs, encompassing errors and other pertinent functionality details encountered during the execution of this process? Your assistance in furnishing this information would greatly aid in the analysis and resolution of any issues .



‼️‼️⚠️Do not upload any attachments that contain sensitive information, such as IP Addresses, URLs, Company/Employee Names, Email Addresses, etc.⚠️ ‼️‼️Refer https://forums.saviynt.com/t5/help/faqpage/title/WhenNotifyAboutPII

[sumagalla]

I have tried the ones which @stalluri and @NM have suggested, they are not working.

@rushikeshvartak Please find attached the logs.

The user update rule name: Workday_Updates_to_AD_for_Primary_Account

username: test000279

[NM]

Hi @sumagalla logs doesn't seem to contain details regarding the rule ..

How do you identify the account is primary add that field in user update condition.

[sumagalla]

In the single endpoint we have Primary and Secondary accounts, there is an enhanced query which runs to update the Primary value in the account type of the users account. I have added the below value in the user update rule, which also have accounttype.

(##a.displayname isupdated##) and a.id in (select distinct us.userkey from User_accounts us, Accounts cc, Endpoints ep where us.accountkey=cc.id and cc.endpointkey =ep.id and ep.endpointname='AD' and cc.accounttype='Primary')

[rushikeshvartak]

When rules triggered?