Get All SharePoint Online Administrators in Office 365

Requirement: Get a list of All users with SharePoint Online Administrator Roles.

How to Get All SharePoint Admins in Office 365?

As a SharePoint Online administrator, you may need to get a list of all other SharePoint Online administrators in your Office 365 environment to have visibility into who has been assigned the role of SharePoint administrator. There are a few ways you can do this, and this article will show you how to get all SharePoint Online administrators in Office 365.

To view all existing SharePoint admins, do the following:

  1. Login to Microsoft Admin Center
  2. Click on “Show All” in the left navigation >> Click on the “Roles” link.
  3. Under Roles, click on “SharePoint Admin” >> Click on the “Assigned Admins” tab in the details pane.
    get all sharepoint online administrators in office 365

This gets you all the SharePoint Admins of the tenant. Please note, Global admin rights include the SharePoint Online Admin role as well!

Get All SharePoint Online Administrator in Office 365 tenant using PowerShell:

To get a list of all SharePoint administrators in Office 365, you can use the Azure Active Directory PowerShell module to retrieve the information. As a regular security audit, we wanted to generate a report of who has admin rights on SharePoint Online. Here is the PowerShell to get all SharePoint Online Administrators:

#Connect to Azure AD
$RoleName="SharePoint Service Administrator"

#Get the Role
$Role = Get-AzureADDirectoryRole | Where {$_.DisplayName -eq $RoleName}

#Get All Members of the Role
Get-AzureADDirectoryRoleMember -ObjectId $Role.ObjectId | Select DisplayName, UserPrincipalName

This script would give a prompt to enter your credentials and connect to your Office 365 tenant, retrieve the SharePoint Administrators role, and then retrieve the members of that role. The list of members will include their display name and user principal name. Here is my other post on adding new SharePoint Online Administrators in Office 365: How to Add New SharePoint Online Administrator?


In summary, By using the Microsoft 365 Admin center or Azure Active Directory PowerShell module, we are able to retrieve a list of all SharePoint administrators in Office 365. This information can be useful for identifying who has access to manage and configure the SharePoint platform, and can help with monitoring and troubleshooting issues. It’s a good practice to keep track of who has access to the SharePoint Admin role in your organization.

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

Leave a Reply

Your email address will not be published. Required fields are marked *