If you want
to list down the users who have Sitecore admin access, you have to go through
each user (to check IsAdministrator checkbox is checked or not) in User Manager
in Security tools. We can also find the list by querying Sitecore ASP.Net
membership tables. Mostly these table will be located in Sitecore Core database.
Query:
/** Getting the list of Users who have Sitecore
admin access **/
SELECT
[ApplicationId]
,[UserId]
,[UserName]
,[LoweredUserName]
,[MobileAlias]
,[IsAnonymous]
,[LastActivityDate]
FROM
[NewInstance1Sitecore_Core].[dbo].[aspnet_Users]
WHERE UserId IN
/** Getting the list of user-ids **/
(SELECT [UserId]
FROM
[NewInstance1Sitecore_Core].[dbo].[aspnet_Profile]
WHERE
/** IsAdministrator Property Name Check **/
[PropertyNames] LIKE
'%IsAdministrator%'
AND
/** Property Value : True or False Check **/
/** !Important: This check should be avoided when
you have other boolean type
custom profile property. And in that
case, just get the User name
without this check and
manually check in User Manager **/
(PropertyValuesString
LIKE '%True%' AND PropertyValuesString NOT
LIKE '%False%'))
This query will return the user details who have admin
access.
Note: If you have any custom Boolean type
profile property, you may need to avoid using the PropertyValuesString values check in the query.
