Modules

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 ROLES

SELECT
distinct r.role_name,
u.USERNAME,
u.SYSTEMUSERNAME,
CASE
when u.statuskey=1 then 'Active'
when u.statuskey=0 then 'Inactive'
END AS 'User Status',
u.FIRSTNAME,
u.LASTNAME,
u.DEPARTMENTNAME
FROM roles r, role_user_account rua, users u
WHERE r.ROLEKEY=rua.rolekey
AND rua.userkey=u.USERKEY;