Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/20/2024 07:21 AM
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')
09/20/2024 07:46 AM
Hi @sumagalla , is accountype populated in account.
Check the query in data analyzer does it give right results ??
09/20/2024 07:48 AM
@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>)
09/20/2024 07:49 AM
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