Export Groups and its members

Hi Niazuddin Shah,

How is your issue going? Has it been resolved yet? If it has, please consider accepting the answer as it helps others sharing the same problem benefit too. Thank you :)

VPHAN

Hi Niazuddin Shah,

In an on-premises environment, you will need to open an elevated PowerShell session and utilize the Active Directory module. You can retrieve the data by piping the results of the Get-ADGroup cmdlet into a loop that processes each group with the Get-ADGroupMember cmdlet. Because Get-ADGroupMember can occasionally encounter issues with groups exceeding the default 5000 member limit defined in the Active Directory Web Services configuration, it is highly recommended to select only the essential properties like the group name and the member's SamAccountName to streamline the query. You can then structure this custom object and pipe it directly into the Export-Csv cmdlet, specifying a local file path such as C:\Temp\ADGroupMembers.csv while appending the NoTypeInformation parameter to keep the resulting file clean.

If your infrastructure relies on Microsoft Entra ID, the methodology shifts to the Microsoft Graph PowerShell module. You must authenticate first by running the Connect-MgGraph cmdlet with the GroupMember.Read.All scope to ensure sufficient directory read permissions. Once connected, retrieve your groups using Get-MgGroup and pass them into a loop using Get-MgGroupMember to query the associated members. The Graph API treats members as generic directory objects, meaning you will need to expand the AdditionalProperties attribute or extract the Id property to resolve the actual user display names accurately. After building your dataset with the group and member details, export it to a local path like C:\Temp\EntraGroupMembers.csv, making sure to include the All parameter on your initial Graph queries to force the system to paginate and capture every object in your tenant.

Hope this answer brought you some useful information. If it did, please hit “accept answer”. Should you have any questions, feel free to leave a comment.

VPHAN