🎉 Our Office 365 Reporting Tool is now available in Azure Marketplace 🚀
This website uses cookies to improve your experience. We'll assume you're ok with this. Know more.

How to Get List of Exchange Online Mailboxes in Microsoft 365

Exchange Online mailboxes are more than just email containers; they're crucial hubs of sensitive data and confidential communication. However, managing bulk mailboxes can be daunting for Microsoft 365 admins. No worries! We'll show you how to easily get Exchange Online mailbox reports for robust and effective management of mailboxes. So, get ready to transform your mailbox monitoring with ease and confidence.

Native Solution

Microsoft 365 Permission Required

High

Global Admin or Exchange Admin.

Option 1 Using Exchange Online Admin Center

  • Sign-in to the Exchange Online admin center.
  • Navigate to ‘Mailboxes’ under ‘Recipients’ to see all mailboxes in Exchange Online.
  • Now, you can click ‘Export all mailboxes’ to get a list of mailboxes in CSV format.
Using Exchange Online Admin Center

Option 2 Using Windows PowerShell

  • Make sure that you have installed and imported the Exchange online module using the below cmdlets.
  • Windows PowerShell Windows PowerShell
     Install-Module -Name ExchangeOnlineManagement
    
    Import-Module ExchangeOnlineManagement
  • Run the below cmdlets to export Exchange Online mailboxes to CSV with their display name, email address, and mailbox type.
  • Windows PowerShell Windows PowerShell
     Connect-ExchangeOnline
    
    Get-Mailbox -ResultSize Unlimited | select Displayname, PrimarySmtpAddress, RecipientTypeDetails | Export-Csv "C:\mailbox_report.csv" -NoTypeInformation
Using Windows PowerShell
  • However, you can't get in-depth mailbox details such as mailbox size, active/inactive status, warning quotas, etc., in the admin center.
AdminDroid Solution
More than 150 reports are under the free edition.

AdminDroid Permission Required

Any user with report access assigned by Super Admin.

StepsUsing AdminDroid Office 365 Reporter

ad
  • Open AdminDroid Office 365 Reporter.
  • Navigate to the ‘All mailboxes’ report under Reports»Exchange»Mailbox Info.
Using AdminDroid Office 365 Reporter

Get the complete list of mailboxes in Microsoft 365 with in-depth mailbox details like primary SMTP address, alias, send quota, receive quota, license status, etc.

chart-view
  • Discover a fresh approach to export Exchange Online reports in Microsoft 365 with advanced insights and dynamic visualizations, powered by both built-in and customizable charts.

Rule your Exchange Online mailbox overview with unified reports!

Microsoft 365 mailbox management at your fingertips! AdminDroid seamlessly provides Exchange Online mailbox reports to giving you complete control over mailboxes.

Witness the report in action using the

Exchange OnlineGet a Complete List of Exchange Online Mailboxes with Their Properties in Microsoft 365

Showing 1 of 6

How to get all mailboxes in Microsoft 365?

Managing a bulk list of Exchange Online mailboxes can be a challenging task for Microsoft 365 organizations.

You can manage them by getting a list of all mailboxes from the below methods:

  • Exchange Online Admin Center: Navigate to the ‘Mailboxes’ section under Recipients which shows all the mailboxes in Microsoft 365.
  • Microsoft PowerShell: Run the PowerShell cmdlet provided to export Office 365 mailbox to CSV in PowerShell.

However, identifying unused mailboxes is crucial to prevent unnecessary license utilization and ensure better mailbox management.

You can audit Microsoft 365 mailboxes to prevent unauthorized access in your organization. Additionally, you can get the mailbox location details such as database location, mailbox location type, and owner ID by using the below PowerShell cmdlet.

Get-mailboxlocation -User <User_id>

With AdminDroid, admins can easily automate the Exchange Online mailboxes report in a required format. It allows admins to verify the mailboxes that are properly managed by authorized individuals.

all-mailboxes-report

Handy Tip: Enable ‘Show advanced options’ in Quick Schedule to allow other admins to subscribe to the scheduler and receive reports regularly in their inbox. It ensures all required admins stay updated with the recent data on all mailboxes in your organization.

How to get all shared mailboxes in Microsoft 365?

Shared mailboxes in Exchange Online are shared resources that are accessed by delegated users in your organization. Therefore, regular monitoring of your shared mailboxes is crucial to maintain secure and reliable mailbox access in Exchange Online.

You can get all shared mailboxes in Microsoft 365 using the below PowerShell cmdlet:

Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize Unlimited
shared-mailboxes-powershell

Additionally, getting a list of shared mailboxes with delegated permissions helps you to identify shared mailboxes’ permissions and monitor them effectively. Specifically, by the list of shared mailboxes with delegated permissions, you can proactively identify mailboxes with inappropriate permissions and manage the discrepancies.

AdminDroid lets you to efficiently monitor list of shared mailboxes in Exchange Online with in-depth details like mailbox size, send quota, receive quote, etc.

  • AdminDroid’s ‘Shared Mailbox Info’ report section provides a range of reports that address permissions, size, forwarding rules, and various other aspects of shared mailbox management in Exchange Online.
  • PRO TIP: The ‘Customize column’ feature enables you to customize your reports by adding, removing, and rearranging a wide range of available columns. You can even add columns from other reports to create a comprehensive view of your Microsoft 365 data.
shared-mailboxes-admindroid

How to export a list of archived mailboxes in Exchange Online?

Archived mailboxes are a valuable repositories for preserving sensitive historical data of the organization, such as emails of former employees, older business conversations, etc. Thus, exporting archived mailboxes report can be useful for auditing and compliance purposes.

You can export a list of archived mailboxes from Exchange Online admin center:

  • Navigate to the ‘Mailboxes’ section under Recipients which shows all Microsoft 365 mailboxes.
  • Apply ‘Archived’ filter to get only archive-enabled mailboxes.
  • Click ‘Export mailboxes in current list’ to export archived mailboxes in Microsoft 365.
admin-archived-mailboxes

You can get list of archived mailboxes in Exchange Online using the below PowerShell cmdlet:

Get-Mailbox -ResultSize Unlimited -RecipientTypeDetails UserMailbox | Where-Object { $_.ArchiveStatus -eq "Active" }| Select DisplayName, PrimarySmtpAddress, @{Label="ArchiveStatus";Expression={ if ($_.ArchiveStatus -eq "Active" -OR $_.ArchiveDatabase -ne $null) { "Enabled" } else {  "Disabled" }}}

You can regularly monitor the list of archived mailboxes to manage the Exchange Online storage effectively. However, the Exchange admin center doesn’t provide storage details of archived mailboxes.

AdminDroid’s Archived mailboxes report will give you an in-depth insights on storage details like archived mailbox size, quote, warning quota, etc.

  • Additionally, auto expanding enabled archived mailboxes can provide additional 1.5TB storage in Exchange Online. To effectively monitor these mailboxes, you can utilize AdminDroid’s Auto Expanding Enabled Archives report with precise storage details.
archived-mailboxes-report
  • By using the Download button, you can easily export a list of all archived mailboxes to your local system in any desired format.

How to get all distribution lists from Office 365?

Distribution lists in Microsoft 365 serves the purpose of efficiently sending emails to a group of users within an organization. It streamlines communication by allowing messages to be distributed to multiple recipients with a single email address.

It is crucial for admins to maintain effective email communication by monitoring distribution lists and their members in Microsoft 365.

You can get all distribution lists in Microsoft 365 from the below steps:

  • Sign-in to the Microsoft 365 admin center.
  • Navigate to ‘Active teams & groups’ under ‘Teams & groups’.
  • Under the ‘Distribution list’ section, you can see all your distribution lists in Microsoft 365.
  • Click ‘Export’ and select ‘Export groups in this list’ to export all distribution list.
distribution-list-admin-center

Use the below PowerShell cmdlets to get all the distribution lists in Microsoft 365.

Connect-ExchangeOnline

Get-DistributionGroup -ResultSize Unlimited

AdminDroid’s Distribution groups report provides a comprehensive overview of all distribution groups with their membership details. It helps to manage the distribution groups and membership statuses to optimize group communication.

Furthermore, AdminDroid ensures hassle-free management of dynamic distribution groups, allows you to effortlessly monitor mailboxes with dynamic memberships.

distribution-groups-admindroid

With a single click on the mailbox icon (✉), you can email your dynamic distribution list report directly to your inbox.

How to export mailbox to PST from Office 365?

Microsoft 365 mailboxes can be exported to PST files and offer a suite of benefits such as data backup, archiving, and offline access to mailbox content. These PST files will ensure easy accessibility and safeguard your valuable email data for future reference.

You can follow the below steps to export mailbox to PST:

Assign export permissions:

  • Sign in to the Microsoft 365 Purview portal with an account having mailbox export permissions, typically assigned in the eDiscovery role group.
  • Navigate to 'Roles & Scopes»Permissions' page and edit the built-in 'eDiscovery role group' under 'Microsoft Purview Solutions»Roles'. Add desired users to give export permissions.

Create a content search:

  • Go to 'Content search»Search' page, click ‘New search’, provide a name & description to your search, and proceed.
  • Toggle on 'Exchange mailboxes' under 'Locations' and choose the desired mailbox to export.
  • In ‘Conditions’, specify required conditions and keywords to export the mailbox based on your requirement.
  • Click 'Next', review your search, and click 'Submit'. Your search will be created.

You can also perform this content search using the below PowerShell cmdlets with the above permissions:

Connect-ExchangeOnline

Connect-IPPSSession

New-ComplianceSearch <SearchName> -ExchangeLocation <UPN>| Start-ComplianceSearch

To export mailbox as PST file:

  • Under the 'Search' tab, select the mailbox you want to export. Click 'Export results' in the 'Actions' dropdown.
  • Select your desired 'Output options' and 'Export Exchange content as'. Prefer 'One PST file for each mailbox' and click 'Export'.

You can also export mailbox as PST file using the below PowerShell cmdlets with eDiscovery role group permissions:

New-ComplianceSearchAction <SearchName> -Export -Format Fxstream

Get-ComplianceSearchAction "<SearchName>_export" -IncludeCredential | FL 

To download the PST file:

  • Upon clicking ‘Export', your search will be reflected in the ‘Export’ tab.
  • Select your search in ‘Export’ tab and copy your ‘export key’ then click ‘Download results'.
  • Your PST file will be downloaded and prompted with an 'eDiscovery Export Tool' installation. After installation, paste your 'Export key' and select the location to store the PST file.
  • Once downloaded, Exchange Online mailbox is exported to PST file and stored in the specified location.

Why do you need to export a list of mailboxes in Microsoft 365?

Exporting a list of mailboxes in Exchange Online can help you identify unused mailboxes that may consume unnecessary resources. You can then remediate these mailboxes by deleting them, archiving them, or disabling them.

Getting a list of mailboxes in Microsoft 365 also includes some other benefits such as:

  • Audit and Compliance You can export list of all mailboxes in Microsoft 365 to audit your organization's Exchange Online environment and ensure compliance with regulatory requirements.
  • Migration You can use Exchange Online mailbox list to migrate your organization's email data to another platform, such as a new Microsoft 365 tenant.
  • Reporting You can use an exported list of mailboxes to generate reports on your organization's email usage, such as the number of mailboxes, the size of each mailbox, and the last time each mailbox was accessed.
  • Troubleshooting You can use the list of mailboxes to troubleshoot email issues, such as identifying mailboxes that are over quota or mailboxes that have not been accessed for a long period of time.

AdminDroid Exchange Online ReporterStreamline mailbox monitoring and management across your organization!

AdminDroid Exchange Online reporting tool emerges as the ultimate solution for Microsoft 365 admins, offering a versatile and user-friendly approach to efficiently export and manage all Office 365 mailbox reports.

Embrace complete visibility of your exchange environment and productive mailbox management experience with AdminDroid

The ‘All mailboxes’ report under Reports»Exchange»Mailbox Info section provides you with detailed information on a list of all mailboxes in Office 365 with details like primary SMTP address, mailbox size, recipient type details, active/inactive status, etc.

A Quick Summary

All-in-one Exchange Mailboxes Details

Experience an advanced statistical view with AdminDroid's mailbox info dashboard, providing an overview of all types of Exchange Online mailboxes.

Proactive Mailbox Quota Management

Gain insights into mailbox size and storage usage across your Microsoft 365 environment, allowing for efficient allocation of storage resources and mailbox quota management.

Automated Reporting for Mailboxes

Get scheduled reports on recently created mailboxes and deleted mailboxes, empowering admins to verify that only authorized individuals create and manage mailboxes, ultimately enhancing mailbox management.

Strategic Mailbox Usage Analysis

Utilize AdminDroid’s detailed mailbox usage reports and analyze the top inactive & storage-consuming mailboxes. It allows you to take prompt actions on unused mailboxes and optimize your Exchange Online resources.

Quick-Scan Mailbox Security

Secure your Office 365 mailboxes with comprehensive Exchange Online mailbox security reports. Monitor critical factors, including mailbox forwarding rules, forwarding addresses, protocol settings, and more with just a few clicks.

In-depth Exchange Online Mailbox Auditing

Elevate your Microsoft 365 security by ensuring detailed Exchange Online mailbox auditing. Gain insights into user activities, mailbox access permissions, inbox rule audit, configuration changes, etc.

In summary, AdminDroid will be a valuable tool for admins who want to streamline Exchange Online mailbox management. It simplifies the complex task of monitoring and exporting all mailboxes in Office 365 with its intuitive interface and powerful reporting capabilities. Create a more secure and productive Exchange Online environment with AdminDroid!

Kickstart Your Journey with AdminDroid

Your Microsoft 365 Companion with Enormous Reporting Capabilities!

Common Errors and Resolution Steps to Export All Exchange Online Mailboxes Report

The following are possible errors and troubleshooting hints while getting all mailboxes report in Microsoft 365.

Error: Export-CSV: Access is denied

This error occurs when the user does not have necessary permissions to save the CSV file to the specified location.

Troubleshooting hint :To export an Exchange list of mailboxes, click ‘Run as administrator’ and open PowerShell with admin permission and run the below cmdlet. Or else, you can save the CSV file to a different location.

Get-Mailbox -ResultSize Unlimited | select Displayname, PrimarySmtpAddress, RecipientTypeDetails | Export-Csv "C:\mailbox_report.csv" -NoTypeInformation

Error: The term 'Get-Mailbox' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

This error will occur while you are running the ‘Get-Mailbox' cmdlet without connecting to the Exchange online.

Troubleshooting hint :To export list of mailboxes in Microsoft 365. Make sure to install and connect to the Exchange Online module by using the following cmdlet.

Connect-ExchangeOnline

Error: PowerShell result shows only your mailbox

This error occurs when you don’t have sufficient permission to read the mailboxes in Exchange Online.

Troubleshooting hint :Contact your global administrator to assign appropriate admin roles.

Error: ResourceUnavailable: Connecting to remote server apc01b.ps.compliance.protection.outlook.com failed with the following error message: For more information, see the about_Remote_Troubleshooting Help topic.

This error occurs if your Exchange Online PowerShell module is not the latest version.

Troubleshooting hint :Update your Exchange Online PowerShell module using the below cmdlet.

Install-Module -Name ExchangeOnlineManagement –Force

Error: New-ComplianceSearch : The term 'New-ComplianceSearch' is not recognized as the name of a cmdlet, function, script file, or operable program.

This error occurs when you try to create a new content search without necessary administrator permissions.

Troubleshooting hint :Contact your global administrator to assign you a ‘Compliance Administrator’ and ‘eDiscovery Manager’ role, which gives permission to export Exchange Online mailboxes to PST.