Issue:
There is not a quick way to see the users and roles they have. Is there a query that could be used to just show the active users and the role groups they are in?
Resolution:
You can use the SQL script below to get a list of the users and roles they are tied to.
select distinct
u.User_Code,u.User_Description,u.EMail_Address,u.First_Name,u.Last_Name,ug.Description as User_Group_Descripion
from sy_user_group_join ugj
inner join SedonaMaster.dbo.SY_User u on u.user_id = ugj.user_id
inner join sy_user_group ug on ugj.user_group_id = ug.user_group_id
Where u.Inactive <>'Y'
order by u.User_Code
The query can be run in the SQL query window in Sedona, Excel or be used to create a quick report in SSRS.
