powershell script to export all the groups and group members from Azure AD

Question

2

Please I need help with a powershell script that can export all the groups and group members of an azure ad and their attributes to a storage account, table storage

Get a list of all Groups in AD first (Get-AzADGroup)

Loop through all Groups and get Members of the group

Loop through all members and get the member info (userprincipal, userid, user, givenname, surname, usertype, accountenabled, etc.) (Get-AzADGroupMember)

Connect to Table Storage (Get-AzStorageAccount)
Get Table Storage Rows (Get-AzTableRow)
Add a Table Row to Table Storage (Add-AzTableRow) using a consistent row key

Answer 1

Hi @tally wizu , have you looked into bulk downloading? https://learn.microsoft.com/en-us/azure/active-directory/enterprise-users/groups-bulk-download-members

This may be faster than creating a PowerShell script. Please let me know if you have any questions!

Best,
James

Answer 2

@James Hamil & @Anshul Kumar (MINDTREE LIMITED) ,

I looked at the referenced article and it looks like it will get what I needed from a single group. I have over 900 groups that I need to get this information so is there an option to download all of the groups and members in the same process and not 1 at a time? The list I am needing also contains my onPrem groups so the one list is all I would need.

Any assistance would be much appreciated and if there is a PS script that generates this that would be Great. I am not trained enough in PS to write an overly complex script.

Michael