Shulou(Shulou.com)06/03 Report--

Hello, everyone, there is a demand today, that is, to count the mailbox capacity of all users in preparation for the migration to OFFICE365, because the capacity we buy on O365 is limited, there are no restrictions on our own management, and some users have used dozens of gigabytes.

I don't know how to use the graphical interface to do this requirement. I looked it up on the Internet and found that some documents are different from the actual ones. In fact, it is a POWERSHELL statement to implement.

The link to the official website is:

Https://technet.microsoft.com/en-us/library/bb124612(v=exchg.160).aspx

I thought it would be easy if this command supported-filter. I could do it one by one OU by OU, until I found the following sentence:

The Get-MailboxStatistics cmdlet requires at least one of the following parameters to complete successfully: Server, Database, or Identity.

You must specify a server, or database or ID

As a result, I made the following sentence:

Get-MailboxStatistics-server mail server name | where {$.ObjectClass-eq "Mailbox"} | Sort-Object TotalItemSize-Descending | ft @ {label= "User"; Expression= {$.DisplayName}}, @ {label= "TotalSize"; expression= {$_ .TotalItemSize}}

| | Export-Csv a.csv |

In fact, after using ft, there will be a problem in export-csv, and the result will be garbled, and then I will use the

Out-file, and then import .txt into EXCEL for editing.

Actually, that's how I use it.

[PS] L:\ > Get-MailboxStatistics-server mail server name | ft @ {label= "User"; Expression= {$.DisplayName}}, @ {label= "TotalSize (MB)"

Expression= {$.TotalItemSize.Value.ToMB ()}}, @ {label= "Database"; expression= {$_ .database}} | Out-File josh.txt

This certainly works, because the exported capacity shows GB and MB, and it is not easy to sort, so an internal function is called to convert it to MB, so it is easy to sort.

Make sure you have write permission to the current directory, otherwise you won't be able to save the files.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.