Query that reports SAV roles assigned to the user

[sharu]

Hi Team,

Need a sql query that reports all the SAV roles assigned to user.

Thanks,

Sharanya V

[rushikeshvartak]

SELECT u.username  AS 'Username',
       u.statuskey AS 'User Status',
       s.rolename  AS 'Role Name'
FROM   users u
       LEFT JOIN user_savroles us
              ON u.userkey = us.userkey
       LEFT JOIN savroles s
              ON us.rolekey = s.rolekey
WHERE  u.statuskey = 1
ORDER  BY u.username,
          s.rolename; 

NOTE : Create analytics report savroles  is not exposed in data analyzer