PowerShell scripts for mailbox statistics report

Mailbox statistics include all information about mailboxes, such as their size, growth, quota limits, last logon details, and so on. You can use the Get-MailboxStatistics cmdlet to fetch the necessary information about your users' mailboxes. This cmdlet works for both Exchange Server and Exchange Online platforms. You can also customize this cmdlet to get the exact results you are looking for.

PowerShell cmdlets for mailbox statistics

1. Get-MailboxStatistics [-Identity] <GeneralMailboxOrMailUserIdParameter> [-Archive] [-CopyOnServer <ServerIdParameter>] [-DomainController <Fqdn>] [-IncludeMoveHistory] [-IncludeMoveReport] [-IncludeQuarantineDetails] [-IncludeSoftDeletedRecipients] [-NoADLookup] [<CommonParameters>]

   Eg. Get-MailboxStatistics -Identity Harry

   This cmdlet helps to retrieve mailbox statistics for the mailbox of the user Harry (alias name).

   Eg. Get-MailboxDatabase | Get-MailboxStatistics -Filter 'DisconnectDate -ne $null'

   This cmdlet helps you to get the mailbox statistics for the disconnected mailboxes in all databases in your organization. 

2. Get-MailboxStatistics -Server <ServerIdParameter> [-DomainController <Fqdn>] [-Filter <String>] [-IncludeMoveHistory] [-IncludeMoveReport] [-IncludePassive] [-IncludeQuarantineDetails] [-NoADLookup] [<CommonParameters>]

   Eg. Get-MailboxStatistics -Server Exchange1

   This cmdlet helps you to retrieve mailbox stats for all the mailboxes stored in the Exchange1 server.

Do more with Exchange Reporter Plus reports

Using PowerShell cmdlets with various parameters to scrutinize and customize your search can become tedious and time consuming. The meticulous work of looking for errors in these cmdlets, like misplaced commas or wrongly-placed hyphens, can be difficult. Exchange Reporter Plus eliminates this issue with intuitive and comprehensive reports that can be generated instantly and analyzed easily.

List of mailbox statistics reports available for Exchange Server

1. Mailbox Size
2. Folder Message Count and Size
3. Inactive Mailboxes by Last Logon Time
4. Logon Failures
5. Disconnected Mailboxes
6. Expired Account Mailboxes
7. Soon-to-expire Account Mailboxes
8. Message Count and Size Summary

List of mailbox statistics reports available for Exchange Online

1. Archive Disabled Mailboxes
2. Inactive Mailboxes
3. Mailbox Folder Statistics
4. Mailbox Size
5. Mailbox Storage Information

To access these reports:

1. Go to the Reports tab in the top pane.
2. Navigate to Exchange Server → Mailboxes or Exchange Online → Mailbox Reports, and then go to the desired category of reports, or simply use the search option in the top-right corner to choose the reports directly by entering their names.
3. Enter the name of the organization and mailbox for which you would like to generate the data.
4. Enter other inputs like the period for report generation, if prompted.
5. Click Generate Now.

This is how Exchange Reporter Plus helps you monitor mailbox statistics. You can export these reports to CSV, PDF, XLS, and HTML formats, and schedule these reports to be automatically generated and sent to your email. This way you can keep a close eye on your mailbox statistics. To learn more about how Exchange Reporter Plus saves you the burden of writing complex PowerShell scripts, click here.