users with no entitlements

[ant]

Hi,

need sql sample query to get active users without entitlement in Saviynt

[sai_sp]

select distinct username, firstname, lastname from users u, user_accounts ua where
u.userkey = ua.userkey
and ua.accountkey not in (select accountkey from account_entitlements1)
and u.statuskey = 1;

@ant This gives list of users who do not have any entitlements assigned in saviynt.

[dgandhi]

The above query suggested by @sai_sp should get the output that you want.

Thanks

[ant]

Does this applied also to those account correlated with systemusernames?

[dgandhi · Accepted solution]

Yes this applies to accounts associated with users since you wanted to find the username with no entitlements.

Thanks