CRM 2011 user security roles listing

This SQL script will give you an result of all active users within the CRM deployment and their security roles

select

u.fullname, u.internalemailaddress, r.name as 'Security Role' from FilteredSystemUserRoles AS sr
inner

join FilteredRole as r on sr.roleid = r.roleid
inner

join FilteredSystemUser as u on u.systemuserid = sr.systemuserid
where

u.isdisabled = 0
order

by u.fullname

Enjoy!