🎉 Our Microsoft 365 Reporting & Management Tool is available in Marketplace 🚀
Microsoft Entra ID

How to Get User Group Membership Report in Azure Active Directory

Are you struggling to keep track of all Microsoft 365 groups a user is a member of? Imagine this: Your organization has multiple groups, projects, and departments, where users frequently engage between them. Managing those users along with their groups can be a real challenge. But don't worry! Explore effective methods to monitor Azure AD user group membership in Microsoft 365.

Microsoft 365 tools
Solution 1
Solution 2
Solution 3
Solution 4
Important Tips
Errors and Resolution Steps

Using Microsoft Entra Admin Center

Microsoft 365 Permission Required
Global Admin or Privileged Role Admin.
  • Sign-in to the Microsoft Entra admin center.
  • Go to 'All Users' tab under Identity»Users.
  • Select a user and then click on Groups under Manage.
  • Now you can see all the groups that the selected user is a member of.
Using Microsoft Entra Admin Center

Using PowerShell Cmdlets

Microsoft 365 Permission Required
Global Admin or Privileged Role Admin.
  • You can use PowerShell to get the group membership of Office 365 users. Install and connect the Azure Active Directory module. Then, run the following cmdlets to retrieve the list of Microsoft 365 groups a user is a member of.
  • Windows PowerShell Windows PowerShell 
     Connect-AzureAD
Get-AzureADUserMembership ‐ObjectId <User Object Id>
Using PowerShell Cmdlets

Using PowerShell Script

Microsoft 365 Permission Required
Global Admin or Privileged Role Admin.
  • To retrieve and export Azure AD users' group membership report in a detailed format without any difficulties, you can simply download and execute the below PowerShell script.
Using PowerShell Script
UserMembershipReport.ps1

Elevate Azure AD user group membership management to new heights!

Say goodbye to tedious scripts and uncover group memberships in a snap! AdminDroid Azure AD reporting and auditing tool provides an intuitive interface that allows you to quickly access and explore a Microsoft 365 user's group membership report, saving valuable time and effort.

Comprehensive List of Azure AD Reports

Effortlessly locate all users and their group membership in your Microsoft 365 environment. Conveniently verify who has access to different resources in a single interface.

Dedicated Dashboard with M365 Insights

Gain a rapid overview of all group report data directly from Azure AD dashboard and utilize deeper insights into your Microsoft 365 environment.

Automated Report Generation and Scheduling

AdminDroid’s scheduling functionality will automatically forward the user membership changes to the manager’s mailbox periodically. Thus ensuring proper membership management.

Various Export Formats and Customization

Export reports in multiple formats with advanced filtering, column merging, and sorting features. Customize your reports to admins' preferences, providing accurate insights for streamlined sharing.

Advanced Alerting for Group Management

AdminDroid provides real-time alerts for group owners' changes that helps Microsoft 365 admins to stay informed about ownership changes and ensures the right users are in charge of group management.

Up-to-date Group Memberships

AdminDroid's hassle-free auto-syncing ensures that you have real-time details on user group memberships. This feature helps you stay updated with recent Microsoft 365 group memberships.

Overall, AdminDroid provides powerful features that empower you to efficiently manage and track Azure AD user group membership list for Microsoft 365 administration. You can also monitor users not in any group, recently created, deleted, enabled and disabled users report, ensuring control over the users in your Office 365 environment.

Important Tips

Implement Microsoft 365 group expiration policy to efficiently manage users who belong to multiple groups. Set expiration dates for certain groups to automatically remove users' group memberships when they expire.

By utilizing group-based access, you can assign or revoke multiple licenses simply by adding or removing users from the group.

Azure AD nested groups allow creating parent groups with subgroups. Users added to parent groups gain automatic access to subgroups, simplifying user management in large organizations.

Common Errors and Resolution Steps

The following are possible errors and troubleshooting hints while dealing with users’ group membership management.

Error Insufficient privileges to add the selected memberships.

This error will appear if the user or admin did not have sufficient privilege to do the action.

Fix Ask your global admin to provide you with the necessary Microsoft 365 group permissions. If you are the global admin and still cannot add members, then the group is likely a dynamic Office 365 group, which manages membership based on predefined conditions.

Error Inherited license assignments cannot be removed from the user directly. To remove the license, you must remove them from their group

This error occurs when you try to directly remove the license of a user when the license assignment is inherited via a group.

Fix Check whether the license assignment is direct or inherited. If it is inherited, remove the member from their group to remove that specific license.

Error You must call the Connect-AzureAD cmdlet before calling any other cmdlets.

When you try to get Azure AD user membership through command lines before connecting the Azure AD module, this error will occur.

Fix To overcome this error, install and connect your Azure AD PowerShell module before using this cmdlet. 
Install-Module AzureAD
Connect-AzureAD

Error You don't have access to this. Your sign-in was successful but you don't have permission to access this resource.

In general, this error occurs when a restriction is imposed by a conditional access policy on your Microsoft 365 account.

Fix Indicate the issue to the admin and ask to exclude you from the conditional access policy to get the Microsoft 365 group membership of a user.

Kickstart Your Journey With
AdminDroid

Your Microsoft 365 Companion with Enormous Reporting Capabilities

Download Now
Browse All Guides
User Help Manuals Compliance Docs Customer Stories
All Guides 99+
Microsoft Entra ID
Get the Group Membership of a Microsoft 365 User
Microsoft Entra ID Guides