Get Mailbox Details in Microsoft 365 using PowerShell 

Get Mailbox Details in Microsoft 365 using PowerShell


This blog will help you get mailbox info with Get-Mailbox PowerShell cmdlets. Also, we have included examples to retrieve mailboxes’ properties. Let’s dive in!

You must connect to Exchange Online PowerShell to use EXO PowerShell cmdlets.

Get All Exchange Online Mailboxes:

To list all the mailboxes, run the Get-Mailbox cmdlet after creating the Exchange Online PowerShell session.

Get-Mailbox –ResultSize Unlimited 

List all mailboxes office 365 PowerShell

Get Mailbox Details using PowerShell:

To view all properties of a mailbox, you can run the Get-Mailbox cmdlet with a specific mailbox identity. For example,

Get-Mailbox –Identity [email protected] | Select * 

It will list 200+ properties of a mailbox ‘John’.

To view specific properties for all the mailboxes, use the following format.

Get-Mailbox -ResultSize Unlimited | Select DisplayName,PrimarySMTPAddress 

The example lists all the mailboxes and their email addresses. To get detailed reports on Microsoft 365 mailboxes’ primary SMTP address and alias, you can refer to the dedicated blog to get all Office 365 email addresses.

List All Shared Mailboxes:

To view all the shared mailboxes in your Exchange online environment, run the cmdlet as below.

Get-Mailbox -ResultSize Unlimited | Where {$_.RecipientTypeDetails -eq “SharedMailbox”} 

List all shared mailboxes

Get Mailbox Size using PowerShell:

To view mailbox size, you can use the Get-MailboxStatistics cmdlet with the mailbox identity. To view all the mailboxes and their size, run the following cmdlet.

Get-Mailbox -ResultSize Unlimited | foreach { Get-MailboxStatistics -identity $_.userprincipalName | select Displayname,TotalItemSize} 

Get mailbox size PowerShell

Note: You can download the pre-built PowerShell script from o365reports.com to get a detailed mailbox size report. Moreover, you can also get mailbox folders and subfolders details to review the each folder size for all mailboxes in the organization.

Export Mailbox Details to CSV:

To export mailboxes and their properties, you can use Export-CSV. For example, to export the archive status of mailboxes, you can run the below cmdlet.

Get-Mailbox -ResultSize Unlimited | Select DisplayName,ArchiveStatus | Export-Csv “D:\Export” -NoType 

You can generate an archive mailbox size report to view the list of archive mailboxes and their size.

View Mailbox Details in Grid View:

Instead of exporting mailbox details to a CSV file, you can view mailbox information in Grid view. Grid view helps you filter or sort the report by a specific column.

To view mailbox details in grid view, use the following cmdlet.

Get-Mailbox –ResultSize Unlimited | Select DisplayName,PrimarysmtpAddress,RecipientTypeDetails,SKUAssigned,AuditEnabled,GrantSendOnBehalfTo | Out-GridView 

Office 365 Get mailbox properties PowerShell

Having Trouble Managing Mailboxes through PowerShell?

If you are a PowerShell novice, it is challenging to identify the appropriate cmdlet to generate desired mailbox report. If you want to get a report with just a few mouse clicks, you can try AdminDroid’s Exchange Online mailbox reports that include,

  • Office 365 mailboxes
  • All active and inactive mailboxes
  • Never logged in mailboxes
  • Mailbox over warning quota
  • Shared mailbox report
  • Mailbox size report
  • Archive mailbox report

AdminDroid Exchange Online auditing tool offers 65+ extensive reports and smart dashboards that provide AI-powered graphical analysis to gain insights and understand the data in a visually appealing manner. From securing your mailboxes efficiently to seamless email management, the possibilities are endless with the valuable reports offered by AdminDroid Exchange Online management tool.

AdminDroid Office-365 reporting tool AI Graph

Besides, AdminDroid offers 190+ Azure AD reports and a handful of dashboards for free to manage your organization’s users, licenses, groups, group membership, membership changes, user logins, password changes, etc. The free version allows you to perform customization, scheduling, and exporting, etc.

Download the Free Office 365 reporting tool by AdminDroid and see how it works for you.

I hope this blog will help you manage mailboxes using PowerShell.

Get Mailbox Details in Microsoft 365 using PowerShell 

by Kathy time to read: 2 min
0