Monday, 28 August 2017

How to get list of Users by Roles in Sitecore

Select T.RoleName ,UserName From (
SELECT RoleName,USERID
  FROM [Core].[dbo].[aspnet_UsersInRoles]
  inner join aspnet_Roles on [Core].[dbo].[aspnet_UsersInRoles].Roleid = aspnet_Roles.RoleId

 ) AS T

 inner join   [Core].[dbo].[aspnet_Users] on T.USERID  = [Core].[dbo].[aspnet_Users].USERID

  order by RoleName


No comments:

Post a Comment

Featured post

Getting Started With SOLR

Getting Started with Solr ·           Features o    Hit highlighting o    Auto correction o    Faceted Search o    Multi lan...