Active Orphan accounts Application Owner Campaign

[William3squivel]

While launching an Application Owner Campaign we noticed that Active Orphan accounts are also being brought into the campaign under username 'admin' what query can we use to only capture these orphan accounts within the Application Owner campaign ? 

[rushikeshvartak]

To get All Orphan :

accountkey not in (select accountkey from user_accounts)

To get All Accounts mapped to User :

accountkey in (select accountkey from user_accounts)