How can I see which users are in no roles?

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!  

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!