Solved

Need some help in modifying Exchange PowerShell to list top 10 mailbox usage in two separate MBX server ?

Posted on 2016-11-01
10
51 Views
Last Modified: 2016-11-16
Hi All,

Can anyone here please assist me to combine or fix the below pwoershell script to be able to display the Top 10 largest mailbox users in GB ?

 Get-MailboxServer | Get-MailboxStatistics | sort-object -descending totalItemSize | Select -First 10 | ft -autosize DisplayName, @{expression={$_.totalitemsize.value.ToMB()};label="Mailbox Size(MB)"}, itemcount, lastlogontime 

Open in new window


There are two separate mailbox server therefore I use the Powershell command Get-MailboxServer to capture both of them, but somehow it does not work ?
0
Comment
  • 5
  • 4
10 Comments
 
LVL 7

Assisted Solution

by:Antzs
Antzs earned 250 total points
ID: 41869543
Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,totalitemcount,lastlogontime,TotalItemSize -First 10
1
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 41869545
Thanks Anthony,

So how can I list the mailbox size in Gigabyte ?
0
 
LVL 15

Accepted Solution

by:
Todd Nelson earned 250 total points
ID: 41869567
Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,@{label="TotalItemSize (GB)";expression={$_.TotalItemSize.Value.ToGB()}},ItemCount,LastLogonTime -First 10 | Export-Csv C:\MailboxSizes.csv -NoTypeInformation

Open in new window

2
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 41869571
THanks Todd and Anthony,

Somehow the TotalItemSize (GB) is not working ?
all of the other columns are shown, only th size is not shown both in the console and on the .CSV file ?
0
 
LVL 7

Expert Comment

by:Antzs
ID: 41869574
Without any additional switches, it is already showing the size in GB.

exchange.png
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 41869575
Hm.. that's odd.

Somehow mine only showing the ItemCount column not the size.
0
 
LVL 7

Expert Comment

by:Antzs
ID: 41869577
If you are you using Exchange 2010, try looking at the below link.

https://blogs.technet.microsoft.com/heyscriptingguy/2013/02/27/get-exchange-online-mailbox-size-in-gb/

I am using Exchange 2013.
1
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 41869586
Ah yes,

I'm using Exchange 2010.
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 41869614
It is still not working ?

Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,@{label="TotalItemSize (GB)";expression={$_.TotalItemSize.ToString().Value.ToGB()}},ItemCount,LastLogonTime -First 10

same result as before.
0
 
LVL 7

Expert Comment

by:Antzs
ID: 41869624
Have a go at this.  Sorry, I don't have an Exchange 2010 to test on.

https://www.petri.com/getting-mailbox-sizes-in-powershell
1

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
The Nano Server Image Builder helps you create a custom Nano Server image and bootable USB media with the aid of a graphical interface. Based on the inputs you provide, it generates images for deployment and creates reusable PowerShell scripts that …
In this video we show how to create a Contact in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Contact ta…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question