Description

get the mailbox size powershell ?

### How to Get the Mailbox Size Using PowerShell

Managing mailboxes in Exchange or Office 365 is a regular task for many IT professionals, and often it’s necessary to check mailbox sizes and usage. PowerShell scripts are invaluable in these situations, providing quick and effective ways to retrieve the necessary information. In this blog post, we’ll explore how to use PowerShell to get the size of all mailboxes in an Exchange environment.

#### Understanding the Scripts

To retrieve the mailbox size of all users, you can use the following PowerShell script. It works by first identifying the mailboxes via the `-Server` parameter, and then extracting the relevant statistics for each mailbox.

“`powershell
Get-MailboxStatistics -Server ‘ExchSVR1’ | Where {$_.ObjectClass -eq ‘Mailbox’} | Select-Object -Property @{label=’User’;expression={$_.DisplayName}}, @{label=’Total Messages’;expression={$_.ItemCount}}, @{label=’Total Size (MB)’;expression={$_.TotalItemSize.Value.ToMB}}
“`

To use this script, you need to replace `’ExchSVR1’` with the name of your Exchange server. The script selects the user display name, total number of messages, and total mailbox size in MB for all mailboxes available on the specified server.

#### Advanced Usage: Displaying Only Specific Information

If you have a large number of users and only need to see certain information, such as the display name and total size, you can adjust your query accordingly.

“`powershell
Get-MailboxStatistics -Server ‘ExchSVR1′ | Select-Object -Property DisplayName, @{label=’Total Size (MB)’;expression={$_.TotalItemSize.Value.ToMB}}
“`

This command is especially helpful for monitoring and optimizing storage space.

#### Custom Reports and Output to CSV

For better organization and distribution of the data, it’s often useful to have it in a CSV file. You can easily export the output to a CSV file like this:

“`powershell
$mailboxStats = Get-MailboxStatistics -Server ‘ExchSVR1’ | Where {$_.ObjectClass -eq ‘Mailbox’} | Select-Object -Property @{label=’User’;expression={$_.DisplayName}}, @{label=’Total Messages’;expression={$_.ItemCount}}, @{label=’Total Size (MB)’;expression={$_.TotalItemSize.Value.ToMB}}
$mailboxStats | Export-Csv -Path “C:filepathmailbox_sizes.csv” -NoTypeInformation
“`

This script not only provides a saved record of user mailbox sizes at a specific point in time but is also useful for auditing and reporting purposes.

#### Get Mailbox Size in Office 365 (Exchange Online)

With Office 365 or Exchange Online, the script is slightly different as you typically connect to the service differently and may have different permissions or cmdlets available. Here’s how you can get all mailbox sizes using Exchange Online:

“`powershell
Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Select-Object DisplayName, TotalItemSize | Export-Csv -Path “C:filepatho365mailboxes.csv” -NoTypeInformation
“`

This particular script requires you to first connect to your Office 365 Exchange Online environment through the Exchange Online PowerShell module.

#### Conclusion

Understanding how to leverage PowerShell to manage and monitor your mailbox sizes can greatly enhance your administrative abilities and provide significant benefits when it comes to maintaining and managing Exchange or Office 365 environments. PowerShell scripting provides a powerful toolset for efficient and effective compliance and management operations. As always, make sure you test scripts in a controlled environment before implementing them in a production setting to avoid any unintended consequences.

By exploring and utilizing these scripts, IT administrators can stay on top of their email systems and prevent any potential mailbox size issues that could affect the performance and functionality of the Exchange environment.