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


1 comment:

  1. Thank you for sharing wonderful information with us to get some idea about it.
    Sitecore Online Training

    ReplyDelete

Featured post

Getting Started With SOLR

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