How the export Azure AD security group members email addresses into CSV?

Question

Hi Forum,How the export Azure AD security group members email addresses into CSV?I tried this PowerShell command:Get-AzureADGroupMember -ObjectId "xxxx...." | Export-csv -path C:\Temp\Output.csvBut, It only generated IDs. How can I get the members email addresses?please, Let me know!

max fritz · Answer

Get-AzureADGroupMember -ObjectId "xxxxx" | select mail | Export-CsvIf you'd like to export all attributes of the users, run this:Get-AzureADGroupMember -ObjectId "xxxxx" | fl | Export-Csv

vasilmichev · Answer

There's no need for that, as the AAD module returns the full object, it's simply not shown in the default formatting. So for example, this will do the trick:
&nbsp;
Get-AzureADGroupMember -ObjectId 84b18857-3c01-48be-b707-492019c57142 | select UserPrincipalName,ProxyAddresses | Export-Csv -nti blabla.csv

deleted · Answer

you'll want to pipe in between there the get-azureaduser in between there to get the user details. so something like get-azureadgroupmember -objectid "xxx" | get-azureaduser | export etc. etc.

deleted · Answer

actually Max's response would work too, I was still asleep this morning, I would take back my response lol.

whatch · Answer

Is there a way to run this script so that I don't have to look up the objectID every time I run the script. I want to run this based on principal name (Email Address).

Forum Discussion

How the export Azure AD security group members email addresses into CSV?

Share

Resources