12-21-2022 10:56 AM
Is there any sepcified query to get active users which dont have access to end_user Sav role, i tried one query but that is showing invalid results, I tried to acess savroles table according to database schema but in data analyser it is not showing me table , only have user_savroles.
Below is my Query:
select u.username as 'Username', u.statuskey as 'User Status' from users u,user_savroles us where u.userkey=us.userkey and us.rolekey<>4 and u.statuskey=1
Can anybody suggest something on this
Solved! Go to Solution.
12-21-2022 11:12 AM - edited 12-21-2022 11:40 AM
select u.username as 'Username', u.statuskey as 'User Status' from users u where userkey not in (select us.userkey from user_savroles us,savroles s where us.rolekey=s.rolekey and s.rolename='ROLE_USER')and u.statuskey=1
This are basic sql skills refer https://www.w3schools.com/sql/sql_intro.asp
12-21-2022 11:25 AM - edited 12-21-2022 11:32 AM
Also SAVRoles is not exposed in Data analyzer but you can run the query including savroles table in analytics