Create a Service Account Campaign targeting specific Account owners

[Community_User]

Originally posted on July 6 2020 at 14:06 UTC

Hello,

In a User Manager Campaign you can select the certifiers from a drop down menu, allowing you to target accounts associated with a particular manager.

In the Service Account campaign, that option isn't there. I wanted to create a campaign to certify accounts which are associated to a few specific owners.

Is there a way to accomplish this in a service account campaign? I don't want to to include all account owners.

Thanks

[Community_User]

Originally posted on July 7 2020 at 07:38 UTC

Hi David,

Currently we have the Accounts Query in the advance configuration where you can query the accounts that has to be a part of the Service Account Campaign.

Thanks,

[Community_User]

Originally posted on July 7 2020 at 07:57 UTC

Hi,

I have hundreds of accounts which are divided among 10 owners. I want to run a campaign targeting only 4 of the 10 owners. Are you saying that I would have to explicitly call out all the actual accounts that are owned by those 4 people and put them in the query?

Regards,

[Community_User]

Originally posted on July 7 2020 at 09:04 UTC

David,

Please filter accounts in the "accounts query" using the account owner attribute.

Please use the below query:

accountkey in(select accountkey from AccountOwners where owneruserkey in (13,2))

Note: 13 and 2 are userkey, please use your userkey

[Community_User · Accepted solution]

Originally posted on July 8 2020 at 12:58 UTC

Hi Brian,

Thank you for that information. To be honest thought I am struggling as I looked up the Schema guide (https://saviynt.freshdesk.com/support/solutions/articles/43000521404-saviynt-security-manager-ssm-sc...) but it doesn't reference "owneruserkey", and I couldn't see a table called "AccountOwners" in the schema.

How do I find out the userkey?

Thanks