Analytics for SAV Role Assignment

[PRATYUSH1]

We want to create an analytic to generate a report which shows which users are assigned to which SAV role. But I am unable to find any table in data analyser where SAV role name is an attribute.

How can I create such an analytic?

[armaanzahir · Accepted solution]

Hi @PRATYUSH1 

Pleas try something along the lines of the below query:

Select u.username AS username, u.firstname AS FirstName, u.lastname AS LastName, u.email AS Email,s.rolename as 'Sav Role Name' FROM users u left join user_savroles us on u.userkey=us.userkey left join savroles s on us.rolekey=s.rolekey

user_savroles - has the user to sav role association

savroles - has the sav role metadata

Please refer to the below link for the table and column names.

Database Schema Reference (saviyntcloud.com)