Consult query doubt

[Community_User]

Originally posted on February 14 2022 at 17:48 UTC

Hi, We're designing a application owner campaign where we want to limit the consult field to users from a certain user group or to only Application owners. Right now, the query we have is: select u from Users u where 1=1 and u.id in (select eo.userkey from com.saviynt.ecm.identitywarehouse.domain.Entitlement_owners eo where eo.rank=2) which uses the entitlement owners table. Can we find out what table to use for application owners or user group? Thank you, Seemran Biswal

[Community_User · Accepted solution]

Originally posted on February 14 2022 at 19:11 UTC

Hello Seemran,

Application owner details are stored within the respective applications i.e. endpoints table.

If the application owner type is a user, then the ownerType field is set to 1 and the ownerkey is set to the corresponding userkey.

If the application owner type is a Group, then the ownerType is set to 2 and the ownerkey is set to the groupkey (from the user_groups table).

Regards,

Avinash Chhetri