Is there any way to get Users who does not have account in particular one endpoint.

[gagan94]

Hey Everyone,

Is there any way to extract users who are active but not associated to particualr one endpoint like Azure AD.

Regards,

Gagan

[rushikeshvartak · Accepted solution]

select u.username from users u where u.userkey not in (select ua.userkey from user_accounts ua ,accounts a,endpoints e where e.endpointkey=a.endpointkey and a.accountkey=ua.accoutkey and e.endpointname='AzureAD')