Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/02/2024 08:59 AM
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))
10/02/2024 12:20 PM - edited 10/02/2024 12:21 PM
@SB2913 , use account type.
a.accounttype in ('primary','service account')
10/02/2024 10:59 PM
Accounts Query :
accountkey IN (SELECT accountkey FROM user_accounts WHERE PRIVILEGED=4)
OR accountkey NOT IN (SELECT accountkey FROM user_accounts)