01-23-2023 04:06 AM
Is there any way to extract users who are active but not associated to particualr one endpoint like Azure AD.
Solved! Go to Solution.
01-23-2023 04:10 AM
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')