The SugarCRM Community is now "read-only" to prepare for the SugarClub launch on August 3. Please visit
Announcing SugarClub - Are you in? for more information.
I need to see which users I have not assigned to a role - what is the best way?
I got assistance from a good Sugar employee. She suggested:
1. Create the following custom query under Advanced Reports:
select user_name, deleted, first_name, last_name from users where deleted=0 and id not in (select user_id from acl_roles_users where deleted=0)order by user_name asc
2. Create a data format and link to the query.
This worked for me!
Retrieving data ...