How to Calculate Exchange 2010 Mailbox Sizes with PowerShell

The Exchange Management Shell, powered by PowerShell, makes it easy to collect size information for the mailboxes in an Exchange 2010 organization.

For example, to list the sizes of all mailboxes on a particular database we can use this command.

[PS] C:\>Get-Mailbox -Database MB-HO-01 | Get-MailboxStatistics | ft displayname,totaldeleteditemsize,totalitemsize

DisplayName      TotalDeletedItemSize    TotalItemSize
-----------      --------------------    -------------
Administrator    0 B (0 bytes)           85.42 KB (87,468 bytes)
Alan Reid        80.08 KB (82,000 bytes) 30.9 MB (32,400,667 bytes)
Alex Heyne       12.35 KB (12,644 bytes) 8.734 MB (9,158,159 bytes)
Aisha Bhari      0 B (0 bytes)           190.4 KB (194,983 bytes)
Aleisha Harrison 0 B (0 bytes)           142.4 KB (145,797 bytes)

If we wanted to know the total size of all of those mailboxes we could output the data to CSV file, import it into Excel, and use formulas to get the results. However that is time-consuming if all you are after is a quick answer.

So instead we can use the Measure-Object command in PowerShell to get the answers we’re looking for. However if we try to use it with the data shown above we’ll get this error.

Measure-Object : Input object "79.95 KB (81,870 bytes)" is not numeric.

So first we need to convert the data into numeric form.

For example, to see the sum, average, minimum and maximum size of the “total item size” for the mailboxes above we run this command.

[PS] C:\>Get-Mailbox -Database MB-HO-01 | Get-MailboxStatistics | %{$_.TotalItemSize.Value.ToMB()} | Measure-Object -sum
 -average -max -min

Count    : 5
Average  : 7.6
Sum      : 38
Maximum  : 30
Minimum  : 0
Property :

Exchange 2010, Exchange Management Shell, Mailboxes, PowerShell

About the Author

Paul Cunningham

About the Author

Paul is a former Microsoft MVP for Office Apps and Services. He works as a consultant, writer, and trainer specializing in Office 365 and Exchange Server. Paul no longer writes for Practical365.com.

Comments

Garrett 23 Aug 2019 Reply

I’m trying to figure out a way to run a script to only show room mailboxes that have a full mailbox I can do this on all users how can I limit this to just room mailboxes.

#Add Exchange Module
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.E2010
Add-PSSnapin Microsoft.Exchange.Management.Powershell.Support

#Declare Arrays
$Mailboxes=$null
$Mailboxes=@()

Get-MailboxDatabase | Get-MailboxStatistics | Where-Object {$_.StorageLimitStatus -match ‘IssueWarning|ProhibitSend|MailboxDisabled’} |% {$Mailboxes += ($_)}

$email = @{
From = “you@yourdomain.com”
To = “you@yourdomain.com”
CC = “you@yourdomain.com”
Subject = “Maiboxes with warnings or full.”
SMTPServer = “mail.yourdomain.com”
Body = ($mailboxes |out-string)
}

send-mailmessage @email
ロレックス激安 7 Sep 2018 Reply

超好評に持った2018ブランドコピー老舗！
2018 新作が満載！皆様を歓迎して当店をご光臨賜ります。
主要取扱商品：ヴィトン、シャネル、エルメスなどのブランドの美品。
◆当店の保証:
スタイルが多い、品質がよい、価格が低い！
安心、安全にお届けします。
品数豊富、色々な選択があります。
ブランドコピー代引きの商品が満載！
100%品質保証！到着保障！
Aleksandrs 10 Aug 2016 Reply

Hi,
In our company we have country specific mail domains. for example @companyname.no, @companyname.se e.t.c

Is it possible to get info on how much for example @companyname.no users have taken space in total. We have exchange 2010
Chris 22 Oct 2015 Reply

Hi,

Thank you for this post. I am trying to accomplish the same thing but for ProhibitSendQuota but not having much luck.

Get-Mailbox -Database MAILBOX-Z | %{$_.ProhibitSendQuota.Value.ToMB()} | Measure-Object -sum -average -max -min
ForEach-Object : You cannot call a method on a null-valued expression.
At line:1 char:36
+ Get-Mailbox -Database MAILBOX-Z | % <<<< {$_.ProhibitSendQuota.Value.ToMB()} | Measure-Object -sum -average -max -min
+ CategoryInfo : InvalidOperation: (ToMB:String) [ForEach-Object], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull,Microsoft.PowerShell.Commands.ForEachObjectCommand

I will need to get the total size of all mailboxes as well as ProhibitSendQuota for several databases so if they can be combined into one command that would be awesome. Tried several different ways of doing it but my attempts so far have been unsuccessful.

Thanks!
1. Paul Cunningham 22 Oct 2015 Reply
  
  Perhaps you should start with this:
  
  https://www.practical365.com/powershell-script-create-mailbox-size-report-exchange-server-2010/
  1. Chris 24 Oct 2015 Reply
    
    Hi Paul,
    
    Thanks for that script I had not seen it before. I used it to generate reports on our 3 MDBs and get the information I was seeking. I had to do all of the calculations through Excel though which I was trying to avoid(and what originally led me to this post).
    
    We wanted to know the sum of the ProhibitSendQuota for all mailboxes as we are looking at storage upgrade options currently. It would be nice to know how to do this without Excel directly in powershell if the need ever arises again.
    
    Thanks
TS79 7 Sep 2015 Reply

Thanks for the article.

Others new to Powershell may appreciate knowing that in this command “%” is an alias for “foreach-object”. Knowing this helps to understand the command.
Nick 3 Jun 2015 Reply

Fair point, and apologies.

Which leads to the question of how to use these inside the ISE after importing the exchange cmdlets though import-pssession ??
Nick 27 May 2015 Reply

Great article.

Does not work remotely, only on the server, so essentially useless for a reporting from your desktop perspective, but great for those who work directly on the console of an exchange server …
1. Paul Cunningham 27 May 2015 Reply
  
  Works from anywhere you’ve got the Exchange Management Shell installed and available. You don’t need to be logged on to an Exchange server for that.
Mark Robinson 4 Dec 2014 Reply

This was a very helpful command and many thanks for publishing the article!

Regards,

Mark
Lydon Carter 3 Jul 2014 Reply

Correction: ” | ft DisplayName,TotalItemSize “
Ripon 2 Jul 2014 Reply

Hi
How can i delete mailbox deleteitemsize………….
TotalItemSize
212;————– ————-
109.8 MB (115,082,027 bytes)
110.3 MB (115,706,464 bytes)
1.153 GB (1,237,562,452 bytes
303 MB (317,687,497 bytes)
142.4 MB (149,329,143 bytes)
333.9 MB (350,112,933 bytes)
608.9 MB (638,477,287 bytes)
1.05 GB (1,127,630,820 bytes)
170.1 MB (178,367,607 bytes)
292.9 MB (307,144,744 bytes)
107.8 MB (112,994,497 bytes)
374.2 MB (392,418,537 bytes)
780.4 MB (818,322,196 bytes)
1.153 GB (1,237,665,369 bytes
233.4 MB (244,743,291 bytes)
252.8 MB (265,043,591 bytes)
360.1 MB (377,567,501 bytes)
104.2 MB (109,275,722 bytes)
112.8 MB (118,247,965 bytes)
136.5 MB (143,160,935 bytes)
184.2 MB (193,194,704 bytes)
561.8 MB (589,077,655 bytes)
450.8 MB (472,737,329 bytes)
6.306 MB (6,612,711 bytes)
449.7 MB (471,554,356 bytes)
484.6 MB (508,166,210 bytes)
274.4 MB (287,710,264 bytes)
365.6 MB (383,311,819 bytes)
253.4 MB (265,751,589 bytes)
826.2 MB (866,321,431 bytes)
493.1 MB (517,032,810 bytes)
273.1 MB (286,353,458 bytes)
312.1 MB (327,254,381 bytes)
38.23 MB (40,086,615 bytes)
284.6 MB (298,435,497 bytes)
5.571 MB (5,841,755 bytes)
329.2 MB (345,210,783 bytes)
978.7 MB (1,026,207,584 bytes
131.9 MB (138,299,717 bytes)
723.4 MB (758,589,732 bytes)
16.17 MB (16,956,192 bytes)
205.2 MB (215,219,481 bytes)
484.3 MB (507,870,667 bytes)
888.3 MB (931,405,683 bytes)
38.93 MB (40,817,149 bytes)
11.6 MB (12,166,925 bytes)
238.2 MB (249,778,787 bytes)
134.9 MB (141,426,235 bytes)
468.5 MB (491,269,783 bytes)
332.3 MB (348,416,341 bytes)
136.9 MB (143,544,574 bytes)
238.4 MB (249,999,807 bytes)
68.99 MB (72,344,941 bytes)
420.2 MB (440,663,194 bytes)
84.4 MB (88,504,422 bytes)
120.6 MB (126,473,662 bytes)
218.5 MB (229,121,978 bytes)
286.8 MB (300,773,709 bytes)
40.91 MB (42,900,845 bytes)
61.28 MB (64,258,851 bytes)
110.2 MB (115,599,512 bytes)
301.1 MB (315,743,928 bytes)
138.5 MB (145,181,976 bytes)
462.5 KB (473,643 bytes)
157.5 MB (165,153,748 bytes)
246.5 MB (258,472,769 bytes)
315 MB (330,340,787 bytes)
312.2 MB (327,385,882 bytes)
407.4 MB (427,183,997 bytes)
6.526 GB (7,007,754,211 bytes
23.09 MB (24,208,003 bytes)
117.1 MB (122,809,200 bytes)
121.1 MB (127,005,893 bytes)
116.7 MB (122,383,496 bytes)
10.72 MB (11,238,282 bytes)
112.2 MB (117,684,625 bytes)
74.82 MB (78,450,958 bytes)
319.7 MB (335,242,113 bytes)
265.4 MB (278,257,603 bytes)
27.8 MB (29,152,929 bytes)
363.6 MB (381,261,554 bytes)
299.8 MB (314,329,966 bytes)
498.9 MB (523,122,181 bytes)
387 MB (405,758,762 bytes)
12.48 MB (13,087,977 bytes)
459.2 MB (481,551,743 bytes)
137.1 MB (143,710,760 bytes)
4.882 MB (5,119,576 bytes)
483.6 MB (507,051,181 bytes)
239.6 MB (251,290,022 bytes)
175.5 MB (184,001,967 bytes)
196.7 MB (206,228,561 bytes)
149.9 MB (157,195,838 bytes)
156.2 MB (163,745,645 bytes)
183.2 MB (192,095,243 bytes)
201.3 MB (211,129,880 bytes)
46.28 MB (48,532,196 bytes)
35.8 MB (37,542,304 bytes)
5.778 GB (6,204,277,917 bytes
556.4 MB (583,423,112 bytes)
125 MB (131,037,812 bytes)
77.66 MB (81,432,110 bytes)
527.3 MB (552,928,844 bytes)
92.33 MB (96,816,300 bytes)
127.8 MB (133,985,531 bytes)
174.4 MB (182,922,505 bytes)
11.7 GB (12,559,585,805 bytes
284.7 MB (298,513,753 bytes)
238.9 MB (250,519,052 bytes)
13.77 KB (14,096 bytes)
179.8 MB (188,505,337 bytes)
31.04 MB (32,543,078 bytes)
506.4 MB (530,994,673 bytes)
34.89 MB (36,581,250 bytes)
1.286 GB (1,381,272,113 bytes
190.8 MB (200,046,471 bytes)
188.4 MB (197,530,239 bytes)
119 MB (124,793,553 bytes)
328.9 MB (344,848,375 bytes)
147.1 MB (154,217,041 bytes)
1.443 MB (1,513,411 bytes)
133 MB (139,482,583 bytes)
188.9 MB (198,122,269 bytes)
269.2 MB (282,264,002 bytes)
1.22 MB (1,279,325 bytes)
160.6 MB (168,397,914 bytes)
150.4 MB (157,718,207 bytes)
213.1 MB (223,464,909 bytes)
165 MB (173,022,347 bytes)
206.5 MB (216,579,892 bytes)
246.8 MB (258,795,153 bytes)
155.9 MB (163,466,251 bytes)
91.94 MB (96,406,416 bytes)
1.455 GB (1,561,909,457 bytes
201.4 MB (211,229,538 bytes)
13.09 GB (14,055,123,400 byte
131.5 MB (137,879,313 bytes)
173 MB (181,427,134 bytes)
5.182 MB (5,433,743 bytes)
40.11 MB (42,063,494 bytes)
76.02 MB (79,716,079 bytes)
42.43 MB (44,490,998 bytes)
186.7 MB (195,751,897 bytes)
132.6 MB (139,084,751 bytes)
15.74 KB (16,117 bytes)
6.765 MB (7,094,102 bytes)
194.9 MB (204,380,593 bytes)
101.6 MB (106,580,926 bytes)
305.6 MB (320,450,654 bytes)
176 MB (184,580,212 bytes)
190.3 MB (199,512,689 bytes)
648.4 MB (679,941,779 bytes)
192.9 MB (202,233,926 bytes)
18.16 MB (19,044,948 bytes)
662.1 KB (677,990 bytes)
71.41 MB (74,876,331 bytes)
27.09 MB (28,408,485 bytes)
32.43 MB (34,010,258 bytes)
141.8 MB (148,656,144 bytes)
378.8 MB (397,251,850 bytes)
606.2 MB (635,669,830 bytes)
478.8 MB (502,098,450 bytes)
5.416 GB (5,815,026,349 bytes
170.9 MB (179,223,072 bytes)
9.159 MB (9,604,104 bytes)
173.7 MB (182,156,355 bytes)
218.6 MB (229,240,217 bytes)
244.4 MB (256,223,423 bytes)
1.342 MB (1,406,906 bytes)
18.51 MB (19,410,816 bytes)
168.9 MB (177,141,047 bytes)
163.9 MB (171,859,725 bytes)
110.2 MB (115,574,442 bytes)
248.1 MB (260,159,947 bytes)
200.6 MB (210,304,951 bytes)
1.439 MB (1,509,076 bytes)
179.8 MB (188,553,828 bytes)
113.5 MB (119,007,940 bytes)
8.902 MB (9,334,332 bytes)
11.16 KB (11,424 bytes)
30.93 MB (32,432,901 bytes)
77.34 MB (81,096,400 bytes)
3.989 MB (4,182,945 bytes)
15.4 KB (15,768 bytes)
177.3 MB (185,885,769 bytes)
10.42 MB (10,929,854 bytes)
160.1 MB (167,855,662 bytes)
545.4 KB (558,494 bytes)
150.9 MB (158,262,207 bytes)
143.3 MB (150,217,199 bytes)
5.088 MB (5,335,500 bytes)
9.902 KB (10,140 bytes)
174.6 MB (183,080,110 bytes)
238.1 MB (249,712,560 bytes)
60.65 MB (63,594,981 bytes)
18.22 MB (19,107,285 bytes)
1. Lydon Carter 3 Jul 2014 Reply
  
  At the end of your command, add the following: ” | ft DisplayName Total,TotalItemSize”
Pingback: Going to callsimon.zendesk.com
Henri 5 Dec 2013 Reply

Hi All,

I’m looking for an PS script to export the size from the trash/recycle bin folder of all user mailboxes in our organisation.

Could some one help a little?
1. Paul Cunningham 6 Dec 2013 Reply
  
  Here you go
  
  https://www.practical365.com/reporting-mailbox-folder-sizes-with-powershell/
Shruti 9 Oct 2013 Reply

Hi Hector,

Use ” | export-csv d:xxxx.csv” at the of the command.
Shruti 9 Oct 2013 Reply

Please tell me how can i collect information about all the Conference rooms in my evviroment whether they have Auto Accept enabled or not?
Hector Fonseca 9 Oct 2013 Reply

Hi Paul.
Excelent Post. So, How I can export the report to csv file?.
Frank 19 Apr 2013 Reply

Is it possible to get this information but instead of seeing the display name, see the email address of the FQDN or something similar?

I’m setting up a hosted exchange and i will have multiple DisplayNames that are the same.
1. Paul Cunningham 19 Apr 2013 Reply
  
  This part of the command determines the attributes that are displayed in the output.
  
  ft displayname,totaldeleteditemsize,totalitemsize
  
  So you can just change that to display any attribute you wish.
Brian 27 Sep 2012 Reply

How would I add a line to gather the users extension in exchange unified messaging?
Pingback: Exchange 2010 – How to check mailbox limits | f i c i l i t y .net
Jeff 16 Jul 2012 Reply

Out of laziness, can I change the parameter to show measurement in MB?
Joe Olivarez 11 Jul 2012 Reply

You’re initially selecting totaldeleteditemsize and totalitemsize, but in the final command you’re only calculating totalitemsize. Can you explain?
1. Paul Cunningham 11 Jul 2012 Reply
  
  Its just an example. You can measure either, or both, its up to you.
Joakim Razafimanantsa 25 May 2012 Reply

Very helpful, but how can I do if I want the total size of AvailableNewMailboxSpace on all DB?
Thank you
1. Lydon 14 Aug 2013 Reply
  
  Just change the scope of the Get-Mailbox to wildcard:
  
  Get-Mailbox ** | Get-MailboxStatistics | %{$_.TotalItemSize.Value.ToMB()} | Measure-Object -sum -average -max -min
2. cbailey 19 Sep 2017 Reply
  
  get-mailboxdatabase | Get-Mailbox | Get-MailboxStatistics | select TotalItemSize | %{$_.TotalItemSize.Value.ToGB()} | Measure-Object -sum -Average -Maximum -Minimum
Pingback: PowerShell Script: Create a Mailbox Size Report for Exchange 2010
Eero 23 Sep 2011 Reply

Is it possible to get same information about Archive Mailboxes?
1. Paul Cunningham 10 Oct 2011 Reply
  
  Sure, just add the -Archive switch to your command.
  
  http://technet.microsoft.com/en-us/library/bb124612.aspx

Subscribe for Practical 365 updates

About the Author

Paul Cunningham

About the Author

Comments

Leave a Reply Cancel reply

Latest Articles

Cloud.Microsoft Domain Changes, Viva Goals Retirement & Copilot Updates: The Practical 365 Podcast S4 E33

Practical 365 Review of 2024

Practical Graph: Understanding What Happens When the Connect-MgGraph Cmdlet Runs