Are you eager to know all SharePoint Online administrators within your Microsoft Office 356 account?

Whether you’re a seasoned administrator seeking to streamline user access or conducting a security audit, pinpointing SharePoint Online Administrators is a crucial task. This guide will show you different ways to find all SharePoint Online Administrators in Office 365 with ease.

How to Check Who is a SharePoint Admin from Microsoft 365 Admin center

One way to check who is SharePoint admin is by using the Microsoft 365 Admin center. This method of checking who is a SharePoint administrator is only accessible if you’re a SharePoint administrator. This means that you need to be an administrator to know who an admin is in SharePoint Online. Follow these steps to check if a user is SharePoint administrator:

1. Login to your Office 365 account (tenant)
2. Click on the App launcher at the top left corner of your page
3. Click on Admin

This will redirect you to Microsoft 365 Admin center.

4.  Expand the User option
5. Click on Active users. This will display all the users currently in your tenant

6. From the list of active users, click on the user you want to check. A user properties tab opens.

On the user properties, scroll down to Roles and you will find the current role of that user. You can follow this same step shown approve to check the roles of all the users in your SharePoint Online account.

This method of finding SharePoint admin is simple but it could be time consuming since it requires you to go over each user’s properties in your tenant account one after another.

📝 Note: As a SharePoint Global Administrator, you can upgrade a user in your tenant from a normal user to an admin user from the Active user’s option in your Microsoft 365 Admin Center.

Another way to find a SharePoint admin from Microsoft 365 Admin center is as follows:

1. Login to your Microsoft Admin center
2. Scroll down and click on Show All at the left navigation pane

3. Expand the Roles option. This will display two sub options (Role assignments and Administrative unit)
4. Click on Role assignments. This will display all the Role assignments for your tenant.

5. Click on SharePoint Administrator
6. A SharePoint Administrator page opens. Click on assigned. This will display all the users that are SharePoint administrator in your tenant

It is important to note that you can check for users in other role assignments by clicking on the desired role assignment and it will display all the users in that role assignment. For instance, you can also check for users who are global administrator by clicking on the Global Administrator Role assignment and this will show all users who are global administrators.

In this method, you do not need to go over the users one after the other to check their status. This method is faster and allows you to see all users in a particular role assignment.

Check all SharePoint Administrator in office 365 Tenant using PowerShell

While the methods described above using the Microsoft 365 Admin center are user-friendly, PowerShell offers a faster and streamlined way, particularly suited for administrators who prefer automation and need to manage multiple users efficiently. PowerShell provides a scriptable interface to interact with Office 365 services, allowing you to retrieve information about SharePoint administrators in a more automated fashion.

Note: You need to have MSOnline modules installed on your computer. Also, ensure that you have the necessary permissions to run these commands. You might need to be assigned the Azure AD administrator role.

To check all SharePoint administrators in your Office 365 Tenant using PowerShell, follow these steps:

#Connect to Azure AD
Connect-MSOLService

1. Run the command to connect to Azure AD. This prompt you for your credentials, provides your administrative valid credentials and it will successfully establish a connection to Azure AD

#Get SharePoint Online Administrators Role
$RoleID = (Get-MsolRole -RoleName "SharePoint Administrator").ObjectID

2. This step retrieves the ObjectID of the SharePoint Administrator role

#Get All Users with SharePoint Admin Role
Get-MsolRoleMember -RoleObjectId $RoleID | Format-table -AutoSize

3. This step fetches all users who have been assigned the SharePoint Administrator role and formats the output in a table.

By following these steps and prerequisites, you can effectively use the PowerShell script to get a list of SharePoint Online administrators in your Office 365 environment.

Also, you can use Azure AD PowerShell to get all SharePoint Online Administrators. To get the SharePoint Online Administrator, use this Azure AD PowerShell script:

#Connect to Azure AD
Connect-AzureAD

1. This step establishes a connection to Azure AD. Make sure you have the AzureAD module installed. You can install it using the following command:

Install-Module -Name Az -AllowClobber -Force -Scope CurrentUser

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

2. This step retrieves the Azure AD role object for “SharePoint Administrator” based on the role’s display name.

# Get All users with the Role
$RoleAssignments = Get-AzureADMSRoleAssignment -Filter "roleDefinitionId eq '$($Role.ObjectId)'"

$RoleAssignments | ForEach-Object {
    $User = Get-AzureADObjectByObjectId -ObjectIds $_.PrincipalId
    If($User.ObjectType -eq "User") {
        $User | Select-Object DisplayName, UserPrincipalName, ObjectType
    }
}

3. This step retrieves all role assignments for the specified role and then iterates through each assignment to get information about the associated users. The user’s display name, user principal name, and object type are selected and displayed.

Using PowerShell can be more efficient, especially when dealing with many users or when automation is essential for routine administrative tasks. This method enables you to quickly gather the necessary information without manually navigating through user properties.

Conclusions

Whether you prefer the user-friendly interface of the Microsoft 365 Admin center or the automation capabilities of PowerShell, identifying and managing SharePoint administrators is pivotal for maintaining a secure and well-organized Office 365 environment.

Combining these methods allows for a comprehensive approach to SharePoint administration, catering to both simplicity and efficiency.