Filter accounts for Update account tasks

[Abdul_Gaffar]

Hi ,

We are trying to specify accounts filter query for update account tasks , however the requirement is that the accounts that have like admin or higher privileges shall not be updated 

for this we might need accounts filter query for update account tasks which is not available

can you please specify if there is another way to achieve this

PFB the screenshot for the requirement regarding

Regards

Abdul Gaffar

[AmitM]

Hi @Abdul_Gaffar , You can use Accounts table in rule Advance config conditions and choose to not run the rule for Admin accounts.

You can follow this doc -https://docs.saviyntcloud.com/bundle/KBAs/page/Content/Obtaining-the-attribute-details-from-tables-o...

Let me know if this helps !!

Thanks,

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.

[rushikeshvartak]

Use query and includes accounts table 

Sample query

a.statuskey=1 and a.id in (select distinct us.userkey from User_accounts us, Accounts ac, Account_entitlements1 ae1, Entitlement_values ev where us.accountkey = ac.id and ac.id = ae1.accountkey and ae1.entitlement_valuekey = ev.id and ev.entitlement_value like '%Entitlement value%' and ac.status = 1 and ac.endpointkey = endpoint key)

[Abdul_Gaffar]

Hi @rushikeshvartak ,

I tried as per specification above and the advance query is below

(##a.customproperty32 notnull## AND ##a.customproperty32 isupdated##) OR (##a.title notnull## AND ##a.title isupdated##) OR (##a.country notnull## AND ##a.country isupdated##) OR (##a.locationdesc notnull## AND ##a.locationdesc isupdated##) OR (##a.street notnull## AND ##a.street isupdated##) OR (##a.departmentname notnull## AND ##a.departmentname isupdated##) OR (##a.customproperty33 notnull## AND ##a.customproperty33 isupdated##) OR (##a.customproperty17 notnull## AND ##a.customproperty17 isupdated##) OR (##a.state notnull## AND ##a.state isupdated##) OR (##a.customproperty16 notnull## AND ##a.customproperty16 isupdated##) OR (##a.locationnumber notnull## AND ##a.locationnumber isupdated##) OR (##a.customproperty27 notnull## AND ##a.customproperty27 isupdated##) OR (##a.customproperty12 notnull## AND ##a.customproperty12 isupdated##) OR (##a.city notnull## AND ##a.city isupdated##) OR (##a.customproperty13 notnull## AND ##a.customproperty13 isupdated##) AND a.id in (select distinct us.userkey from User_accounts us, Accounts ac where ac.name not like 'PA1%' and ac.name not like 'PA2%' AND ac.name not like 'PA0%' AND ac.name not like 'd\\_%' AND ac.name not like '%.adm')

However , when I triggered one user which had a PA1 account , got triggered with a pending task

can you please specify if I am missing anything

Thanks 

Abdul Gaffar

[rushikeshvartak]

notnull is wrong syntax 

[Abdul_Gaffar]

Hi @rushikeshvartak ,

In that case can you please suggest the correct syntax for not null as well as the account filter specified as in a.id in (select distinct us.userkey from User_accounts us, Accounts ac where ac.name not like 'PA1%' and ac.name not like 'PA2%' AND ac.name not like 'PA0%' AND ac.name not like 'd\\_%' AND ac.name not like '%.adm') is correct ?

Thanks & regards

Abdul Gaffar