Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/10/2023 10:42 AM
05/10/2023 02:02 PM
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.
05/10/2023 04:23 PM
The above query suggested by @sai_sp should get the output that you want.
Thanks
Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.
05/15/2023 03:47 AM
Does this applied also to those account correlated with systemusernames?
05/15/2023 06:46 AM
Yes this applies to accounts associated with users since you wanted to find the username with no entitlements.
Thanks
Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.