Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Application Owner Campaign Type Combining Account & Entitlement Query

SB2913
New Contributor
New Contributor

We have created an Application Owner (AO) Campaign type to look for privileged accounts. We noticed that we can also use the Application Owner Campaign type to search for Service Accts by modifying the original AO campaign. We are stuck trying to combine both in a single campaign: return privileged accts, and also return service accts. We have the following basic queries in the Advanced Campaign Configuration section below.

Application Owner Campaign Type (Looking for privileged accts):
Accounts Query->
accountkey in (select accountkey from user_accounts)

Entitlements Query->
PRIVILEGED=4

Application Owner Campaign Type (looking for Service accts):
Accounts Query->
accountkey NOT in (select accountkey from user_accounts)

Entitlements Query->
(empty)

What would be the best way of combining both of these queries? Do we need to use the "Accounts Entitlements 1" query as well? Is there a recommended post, or documentation that explains further on how to use the AE1 query section? Is it possible to combine looking for privileged accts, and service accts in the same campaign?

We tried using the following query below with no success.

(PRIVILEGED=4 OR (accountkey NOT in (select accountkey from user_accounts))

2 REPLIES 2

NM
Honored Contributor II
Honored Contributor II

@SB2913 , use account type.

a.accounttype in ('primary','service account')

rushikeshvartak
All-Star
All-Star

Accounts Query :

accountkey IN (SELECT accountkey FROM user_accounts WHERE PRIVILEGED=4)
OR accountkey NOT IN (SELECT accountkey FROM user_accounts)


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.