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

Technically speaking, this is a matter of two mouse clicks, but our background is always messy.

Background information: originally, the people who built the server did not make a quota for the mail database, the users just used it as they wanted, and the former employees did not clean up the mailbox data, which directly led to the increasing size of the mail database and the basic depletion of storage space.

Now it is mentioned that a requirement is to set a quota without giving a standard, which is obviously not a technical problem, so the routine of our IT is:

Step 1: check which databases do not have quotas from the mail server

The Powershell command used:

Get-MailboxDatabase-Server your own mail server name | select-Object IssueWarningQuota,ProhibitSedReceiveQuota,ProhibitSendQuota

Step 2: find the user's mailbox size from the mail server

Get-MailboxStatistics-Server your own mail server name | Select-Object DisplayName,TotalItemSize | Export-CSV D:\ what file name. Csv

Remember to use the administrator identity when opening exchange powershell, otherwise you can't write the file to disk.

Step 3: collate the data and sort

DisplayName TotalItemSize

The above is what your CSV file looks like, and it needs to be dealt with, so there are skills at this time.

First use the search and replacement in EXCEL, directly press ctrl plus f to bring up the tool window, enter (asterisk) in parentheses in the search, there is no way to enter an asterisk, replace nothing, click to replace all. The disgusting parentheses and their contents disappeared.

Then use the formula to separate the values from the units in a column and copy the formula of the link below. it's easy to use, no matter why the formula is done, just use it.

Http://www.office68.com/excel/19334.html

There is also a pit, that is, the column in which you separate the display value is of text type, and there is no way to sort it. The solution is to insert a column next to it, and then use that column of that text to directly multiply a number 1. Hehe, it becomes a numerical value, and then you sort it.

Step 4: leave it to management to decide and set quota standards

Step 5: submit it to the management meeting for approval

Step 6: send a notice and bring a manual on how to download the email to the local area.

Step 7: set the quota by the deadline.

I plan to record Powershell videos in June, with an estimated 100 sections, each of which is limited to 5 to 10 minutes. If you do Windows system management, will not Powershell, life is not perfect, hope to have fate to support.

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.