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?

[sumagalla]

It is creating two taks for AD, one is for primary account and other for secondary account. Not understanding why it's triggering for secondary account too even though I have given the condition to trigger only for primary account.

[rushikeshvartak]

Did you added account type under endpoint as primary account

[sumagalla]

Yes, it is already there.

[rushikeshvartak]

Share logs in text file

[sumagalla]

Please find attached the logs

The user update rule name: Workday_Updates_to_AD_for_Primary_Account

username: test000279

Tasks Created: 125570, 125569

[sumagalla]

PFA the logs

[sumagalla]

Any update on this ?

[rushikeshvartak]

You can create enhanced query job to discontinue task created from rule ( source='ZERODAY' or 'PROVRULE) and for secondary account

[Saathvik]

@sumagalla : Can you share the screenshot of the update rule?  Workday_Updates_to_AD_for_Primary_Account

From the logs I see it was running different query than what you have used so wanted to double check the rule

[sumagalla]

Please find the rule below:

[rushikeshvartak]

Full screenshot please with rule name and trigger when

[sumagalla]

Please find the user update rule full screenshot below