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.