Forum Discussion
Marvin Oco
Jul 01, 2019Iron Contributor
powershell script to export display name and primary smtp address of all users
what is the powershell script to export display name and primary smtp address of all users?
thanks
2 Replies
Sort By
- kathyBrass Contributor
You can run below code to export all office 365 mailboxes' DisplayName and PrimarySMTPAddress to CSV file.
Get-Mailbox -Resultsize Unlimited | select DisplayName,PrimarySMTPAddress | Export-csv E:\O365Users.csv -NoType -Append
If you need additional attributes like license details, mfa status and mailbox permissions, you can refer this blog: https://o365reports.com/2019/05/09/export-office-365-users-mfa-status-csv/
- Hi Marvin Oco
https://o365info.com/export-and-display-information-about-email-addresses-using-powershell-office-365-part-6-13/
See section - Export PowerShell command output to a CSV file
Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,PrimarySmtpAddress,EmailAddresses,EmailAddresses | Export-CSV C:\Temp\"Exchange Online recipients.CSV" –NoTypeInformation -Encoding UTF8
Hope that helps
Best, Chris