can we use account status in advanced query

[Srinivas_N]

Hi,
can someone suggest me is it possible to use account status in rules through advanced query.
It would be great if you could share me some reference.
thanks in advance.

Regards,
Srinivas

[rushikeshvartak]

yes

(a.customproperty8 = 'xxxxxxx') and a.statuskey=1 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 cc.status=1 and ep.endpointname in ('Aloy_AD_SaviyntPOC_Test1','Aloy_AD_SaviyntPOC_Test1')) 

https://forums.saviynt.com/t5/identity-governance/add-to-role-only-if-account-exist-at-endpoint/m-p/...

[Amit_Malik]

Hi @Srinivas_N ,

Please refer this Saviynt doc - https://docs.saviyntcloud.com/bundle/KBAs/page/Content/Obtaining-the-attribute-details-from-tables-o...

This explains you how to refer different tables in rules with right syntaxes (HQL Class Names) 

Sample Query from same doc :

a.jobcodedesc='IAM Administrator' 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='Open DJ - LDAP')

Thanks,

Amit

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