Skip to main content

Exchange 2013 Get Top Mailboxes by Size through Powershell

Get Top Mailboxes By Size in Powershell

Problem:

One of my friend running exchange 2013 had mailbox database named DB3 size increasing rapidly, so he asked to help him get a list of Top 50 Mailbox users by size, so he can monitor these mailboxes.
As the problem was related to only Database named “DB3” so we only want report for that specific database.

Solution:

The article describes step by step procedure on how to get Top Mailboxes By Size through Powershell in Exchange 2010 or Exchange 2013. Powershell makes it easy to get such kind of reports. So this is the final command i suggested him to run through Exchange Powershell
Get-mailboxdatabase -identity DB3 | Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,TotalItemSize -First 100 | Export-CSV Top50Mboxes-Db3.csvExplanation:Get-mailboxdatabase -identity DB3 this command gets the data from the Database DB3

Get-Mailbox -ResultSize Unlimited this command brings all of the mailboxes in this database

Get-MailboxStatistics this command brings the statistics about all the mailboxes in DB3

Sort-Object TotalItemSize -Descending this commands sorts the mailboxes by size (Largest first)

Select-Object DisplayName,TotalItemSize -First 50 now we can select the columns that we want to display and -first 50 gives us the top 50 mailboxes in DB3 by size.

Export-CSV D:Top50Mboxes-Db3.csv and finally we export the output to the csv on D: drive

Email Sharing

SMTP Sharing after Two Companies Merged Part2

STMP Sharing after two companies merged (2nd part)

Couple of months ago, i posted the 1st part of SMTP Sharing after companies merged.That gave an overview of the requirements and 6 steps that were going to be performed. In this article, i will be giving more details about the first 3 step.

Step 1:

Configure network connectivity between Company A and Company B.Open the following ports:

 
Purpose
Source
Destination
Port
Comments
Name Resolution
Domain Controllers in Company A
Domain Controllers in Company B
53
(TCP, UDP)
DNS Servers Communication
From A to B
Name Resolution
Domain Controllers in Company B
Domain Controllers in Company A
53
(TCP, UDP)
DNS Servers Communication
From B to A
Exchange HUB/CAS Communication
Company A Mailbox Server IPs
Company B Hub Server IP
25
(TCP)
Allow Exchange Servers Communication in Company A
Exchange HUB/CAS Communication
Company B Hub Server IP
Company A Mailbox Server IPs
25
(TCP)
Allow Exchange Servers Communication in Company B

Step 2:

Configure External DNS registration for the new CompanyC.com domain
First we have to register CompanyC.com domain and then add the A, PTR and MX records
A and PTR Records.

Domain FQDN
Mail Server FQDN
IP Address
Firewall Natting
CompanyC.com
Mail1.CompanyC.com
Public IP for Company A Exchange
Already Natted
For CompanyA.com Exchange
CompanyC.com
Mail2.CompanyC.com
Public IP for Company B Exchange
Already Natted
For CompanyB.com
Exchange

MX Records

Domain FQDN
Mail Server FQDN
Priority
Comments
CompanyC.com
Mail1.CompanyC.com
10
 
CompanyC.com
Mail2.CompanyC.com
20
 

Note: Company A will only be receiving point for the emails of CompanyC.com domain that’s why it has priority 10.

Step 3:

Create accepted domain as Internal Relay in each domain.
Open the ECP, go to mail flow and then “accepted domain” tab.

Accepted Domains

Current accepted domain will be shown, click on plus sign to add CompanyC.com

Add the accepted domain as Internal Relay.

In the next article i will discuss the remaining 3 steps.