Modules
Browse queries by module.
All Modules
ARS Requests ARS Tasks Accounts Accounts, Endpoint Accounts, Endpoints Analytics Audit Logs Audit Trail Campaign Certification Connections Connections, Job Control Panel Endpoints Job Control Panel Roles Rules Security Systems User Group Users Users, Accounts Users, Accounts, Endpoint Users, Entitlements Users, Roles Users, SAV ROLESUser details of ALL SAV ROLES
Module: Users, SAV ROLES
Description
Get all users with statuskey that belong to a particular SAV Role
Dynamic Input
nan
Execute in
Analytics
SQL Query
SELECT u.username,
u.firstname,
u.lastname,
u.email,
us.rolekey AS ROLE_KEY,
sr.rolename,
us.updatedate AS UPDATE_DATE,
us.updateuser AS UPDATEUSER_KEY,
uu.username AS UPDATEDUSERNAME
FROM users u
JOIN user_savroles us
ON u.userkey = us.userkey
JOIN savroles sr
ON us.rolekey = sr.rolekey
LEFT JOIN users uu
ON us.updateuser = uu.userkey
WHERE u.statuskey = 1;
Comments
nan
User details of a Specific SAV ROLES
Module: Users, SAV ROLES
Description
Get all users with statuskey that belong to a particular SAV Role
Dynamic Input
SAV ROLE Name
Execute in
Analytics
SQL Query
SELECT u.username,
u.firstname,
u.lastname,
u.email,
us.rolekey AS ROLE_KEY,
sr.rolename,
us.updatedate AS UPDATE_DATE,
us.updateuser AS UPDATEUSER_KEY,
uu.username AS UPDATEDUSERNAME
FROM users u
JOIN user_savroles us
ON u.userkey = us.userkey
JOIN savroles sr
ON us.rolekey = sr.rolekey
LEFT JOIN users uu
ON us.updateuser = uu.userkey
WHERE u.statuskey = 1
AND sr.rolename = 'ROLE_ADMIN';
Comments
nan
Query copied!