Get-MailboxStatistics

Question

Hi All

i am using exchange 2010 hybrid envioronment, we create users in onprem and migrate it to cloud. i have DL's in onprem and cloud, i have shared mailboxes created in onprem and migrated to cloud. I want to export list of mailboxes, shared mailboxes, DL's and unified groups to csv file.
I want to export DisplayName, PrimarySMTPAddress, email address & upn to csv file. Experts help me with the syntax.

Answer 1

Hi @Roger Roger

Check if below commands work for you:

Get-mailbox -RecipientTypeDetails UserMailbox | Select DisplayName, PrimarySmtpAddress, EmailAddresses, UserPrincipalName | Export-csv C:\test\usermailboxes.csv -NoTypeInformation  
Get-mailbox -RecipientTypeDetails sharedmailbox | Select DisplayName, PrimarySmtpAddress, EmailAddresses, UserPrincipalName | Export-csv C:\test\sharedmailboxes.csv -NoTypeInformation  
Get-DistributionGroup | Select DisplayName, PrimarySmtpAddress, EmailAddresses | Export-csv C:\test\DLs.csv -NoTypeInformation  
Get-UnifiedGroup | Select DisplayName, PrimarySmtpAddress, EmailAddresses | Export-csv C:\test\Unifiedgroups.csv -NoTypeInformation  

You will get CSV file like below:

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.