1. 查询一个角色下面有多少用户

select * from SystemUser a join systemuserroles b
on a.SystemUserId=b.SystemUserId
join Role c
on b.RoleId=c.RoleId
where c.Name=‘System Administrator‘ 
and a.IsDisabled=0

CRM 常用SQL 脚本