SELECT
SU.FullName,
SU.DomainName,
Role.Name,
SUR.RoleId,SUR.SystemUserId
FROM Role
JOIN SystemUserRoles SUR ON (Role.RoleId = SUR.RoleId)
JOIN SystemUser SU ON (SUR.SystemUserId = SU.SystemUserId)
WHERE
(Role.DeletionStateCode = 0) AND
(SU.IsDisabled = 0) AND
(SU.DeletionStateCode = 0)
SU.DomainName,
Role.Name,
SUR.RoleId,SUR.SystemUserId
FROM Role
JOIN SystemUserRoles SUR ON (Role.RoleId = SUR.RoleId)
JOIN SystemUser SU ON (SUR.SystemUserId = SU.SystemUserId)
WHERE
(Role.DeletionStateCode = 0) AND
(SU.IsDisabled = 0) AND
(SU.DeletionStateCode = 0)
No comments:
Post a Comment