Mailbox reporting

In this section, we will review a simple example where certain selected or all the properties of mailbox objects can be exported to a CSV file for review. For instance, you are an administrator of a company who is planning to move to Exchange Online and wants to find out the mailbox sizes of the user mailboxes.

We will use a combination of Get-Mailbox, Get-MailboxStatistics, Select-Object, and Export-CSV cmdlets:

Get-Mailbox | Get-MailboxStatistics | Select-Object DisplayName, ItemCount, TotalItemSize | Export-CSV "ExistingMailboxSize.csv"

Based on your requirements, you can build a complex script that can take multiple parameters as input, will do data conversion, and even send an email to specific people displaying the report in the HTML format. A simple example of a script is shared in the last topic of this chapter.