<div>
Replace SERVER with your email server name 
 

<pre><code class="code-1 nolinks" id="code-20-42059134-1">get-mailbox -server &quot;server&quot; -ResultSize unlimited | Where {$_.UseDatabaseQuotaDefaults -eq $false} | Sort-Object DisplayName | ft DisplayName,IssueWarningQuota,ProhibitSendQuota &gt; C:\quota_exceptions.txt
</code></pre>
</div>

<div>
the above wont give me total mailbox size and what percentage till it reaches it quota
</div>

<div>
Hello , 
 
Please try the below logic, 
 

<pre><code class="code-10 nolinks" id="code-20-42059944-1">$users = get-mailbox -recipientypedetails &quot;usermailbox&quot; -resultsize unlimited
Foreach ($user in $user)
{
 $mx = Get-Mailbox -Identity $user
 $mxs = Get-MailboxStatistics -Identity $user
 $properties = @ { alias = $mx.alias
 currentsize = $mxs.totalitemsize
 Totalsize = $mx.prohibitsendreceivequota
 }
 $obj = New-Object -typename psobject -property $properties
 Write-output $obj
}
</code></pre>
</div>

<div>
could i use above to query all mailboxes?
</div>

<div>
Yes, it will for all user mailboxes, if you want to query all mailboxes , then remove -recipientypedetails &quot;usermailbox&quot; on first line
</div>

<div>
i try to do a | export-csv but it fail any help with that would be appreciated
</div>

<div>
try this, 
 

<pre><code class="code-10 nolinks" id="code-20-42060014-1">$users = get-mailbox -recipientypedetails &quot;usermailbox&quot; -resultsize unlimited
Foreach ($user in $user)
{
 $mx = Get-Mailbox -Identity $user
 $mxs = Get-MailboxStatistics -Identity $user
 $properties = @ { alias = $mx.alias
 currentsize = $mxs.totalitemsize
 Totalsize = $mx.prohibitsendreceivequota
 }
 $obj = New-Object -typename psobject -property $properties
}
$obj | select-object alias,currentsize,totalsize | export-csv &quot;filename.csv&quot;
</code></pre>
</div>

<div>
[PS] C:\Users\adm\Desktop&gt;.\MailboxQuota.ps1 
Unrecognized token in source text. 
At C:\Users\adm\Desktop\MailboxQuota.ps1:6 char:21 
+ &nbsp; &nbsp; &nbsp; $properties = &nbsp;&lt;&lt;&lt;&lt; @ { alias = $mx.alias 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: ParserError: (:) [], ParseException 
&nbsp; &nbsp; + FullyQualifiedErrorId : UnrecognizedToken
</div>

<div>
hi dinesh i am getting the above error message any help would be appreciated.
</div>

<div>
awesome exactly what i needed i try to export-csv and it gives me an error any help with that would be appreciated.
</div>

<div>
Yes,, just replace last line with 
 

<pre><code class="code-1 nolinks" id="code-20-42060175-1">$Report |Sort-Object QuotaPercent -Descending |Export-CSV c:\temp\QUOTA.csv
</code></pre>
 
Or you can set different location
</div>

<div>
Error all over any advise would be appreciated 
 
Exception calling &quot;ToInt64&quot; with &quot;1&quot; argument(s): &quot;Input string was not in a correct format.&quot; 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:51 char:71 
+ &nbsp; &nbsp; [int64]$usr_mailboxstats_totaldeleteditemsize = [convert]::ToInt64 &lt;&lt;&lt;&lt;&nbsp;(((($usr_mailboxstats.TotalDeletedItemSize.ToString().split(&quot;(&quot;)[-1]).split(&quot;)&quot;)[0]).split(&quot; &quot;)[0]-replace '[,]','') 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], MethodInvocationException 
&nbsp; &nbsp; + FullyQualifiedErrorId : DotNetMethodException 
 
Exception calling &quot;ToInt64&quot; with &quot;1&quot; argument(s): &quot;Input string was not in a correct format.&quot; 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:60 char:47 
+ &nbsp; &nbsp; &nbsp; &nbsp; [INT64]$usr_quota = [convert]::ToInt64 &lt;&lt;&lt;&lt;&nbsp;(((($usr_mailbox.ProhibitSendQuota.ToString().split(&quot;(&quot;)[-1]).split(&quot;)&quot;)[0]).split(&quot; &quot;)[0]-replace '[,]','')) 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], MethodInvocationException 
&nbsp; &nbsp; + FullyQualifiedErrorId : DotNetMethodException 
 
Attempted to divide by zero. 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:63 char:112 
+ &nbsp; &nbsp; $usr_quota_percentage = [INT]((($usr_mailboxstats_totalitemsize + $usr_mailboxstats_totaldeleteditemsize) / &lt;&lt;&lt;&lt;&nbsp; $usr_quota)*100) 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], RuntimeException 
&nbsp; &nbsp; + FullyQualifiedErrorId : RuntimeException 
 
Exception calling &quot;ToInt64&quot; with &quot;1&quot; argument(s): &quot;Input string was not in a correct format.&quot; 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:49 char:64 
+ &nbsp; &nbsp; [int64]$usr_mailboxstats_totalitemsize = [convert]::ToInt64 &lt;&lt;&lt;&lt;&nbsp;(((($usr_mailboxstats.TotalItemSize.ToString().split(&quot;(&quot;)[-1]).split(&quot;)&quot;)[0]).split(&quot; &quot;)[0]-replace '[,]','')) 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], MethodInvocationException 
&nbsp; &nbsp; + FullyQualifiedErrorId : DotNetMethodException 
 
Exception calling &quot;ToInt64&quot; with &quot;1&quot; argument(s): &quot;Input string was not in a correct format.&quot; 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:51 char:71 
+ &nbsp; &nbsp; [int64]$usr_mailboxstats_totaldeleteditemsize = [convert]::ToInt64 &lt;&lt;&lt;&lt;&nbsp;(((($usr_mailboxstats.TotalDeletedItemSize.ToString().split(&quot;(&quot;)[-1]).split(&quot;)&quot;)[0]).split(&quot; &quot;)[0]-replace '[,]','') 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], MethodInvocationException 
&nbsp; &nbsp; + FullyQualifiedErrorId : DotNetMethodException 
 
Exception calling &quot;ToInt64&quot; with &quot;1&quot; argument(s): &quot;Input string was not in a correct format.&quot; 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:60 char:47 
+ &nbsp; &nbsp; &nbsp; &nbsp; [INT64]$usr_quota = [convert]::ToInt64 &lt;&lt;&lt;&lt;&nbsp;(((($usr_mailbox.ProhibitSendQuota.ToString().split(&quot;(&quot;)[-1]).split(&quot;)&quot;)[0]).split(&quot; &quot;)[0]-replace '[,]','')) 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], MethodInvocationException 
&nbsp; &nbsp; + FullyQualifiedErrorId : DotNetMethodException 
 
Attempted to divide by zero. 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:63 char:112 
+ &nbsp; &nbsp; $usr_quota_percentage = [INT]((($usr_mailboxstats_totalitemsize + $usr_mailboxstats_totaldeleteditemsize) / &lt;&lt;&lt;&lt;&nbsp; $usr_quota)*100) 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], RuntimeException 
&nbsp; &nbsp; + FullyQualifiedErrorId : RuntimeException 
 
Exception calling &quot;ToInt64&quot; with &quot;1&quot; argument(s): &quot;Input string was not in a correct format.&quot; 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:49 char:64 
+ &nbsp; &nbsp; [int64]$usr_mailboxstats_totalitemsize = [convert]::ToInt64 &lt;&lt;&lt;&lt;&nbsp;(((($usr_mailboxstats.TotalItemSize.ToString().split(&quot;(&quot;)[-1]).split(&quot;)&quot;)[0]).split(&quot; &quot;)[0]-replace '[,]','')) 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], MethodInvocationException 
&nbsp; &nbsp; + FullyQualifiedErrorId : DotNetMethodException 
 
Exception calling &quot;ToInt64&quot; with &quot;1&quot; argument(s): &quot;Input string was not in a correct format.&quot; 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:51 char:71 
+ &nbsp; &nbsp; [int64]$usr_mailboxstats_totaldeleteditemsize = [convert]::ToInt64 &lt;&lt;&lt;&lt;&nbsp;(((($usr_mailboxstats.TotalDeletedItemSize.ToString().split(&quot;(&quot;)[-1]).split(&quot;)&quot;)[0]).split(&quot; &quot;)[0]-replace '[,]','') 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], MethodInvocationException 
&nbsp; &nbsp; + FullyQualifiedErrorId : DotNetMethodException 
 
Exception calling &quot;ToInt64&quot; with &quot;1&quot; argument(s): &quot;Input string was not in a correct format.&quot; 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:60 char:47 
+ &nbsp; &nbsp; &nbsp; &nbsp; [INT64]$usr_quota = [convert]::ToInt64 &lt;&lt;&lt;&lt;&nbsp;(((($usr_mailbox.ProhibitSendQuota.ToString().split(&quot;(&quot;)[-1]).split(&quot;)&quot;)[0]).split(&quot; &quot;)[0]-replace '[,]','')) 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], MethodInvocationException 
&nbsp; &nbsp; + FullyQualifiedErrorId : DotNetMethodException 
 
Attempted to divide by zero. 
At C:\Users\adm\desktop\MailboxSizeQuota.ps1:63 char:112 
+ &nbsp; &nbsp; $usr_quota_percentage = [INT]((($usr_mailboxstats_totalitemsize + $usr_mailboxstats_totaldeleteditemsize) / &lt;&lt;&lt;&lt;&nbsp; $usr_quota)*100) 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], RuntimeException 
&nbsp; &nbsp; + FullyQualifiedErrorId : RuntimeException
</div>

<div>
Script is working because I've tested. 
 
#TYPE System.Management.Automation.PSCustomObject &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
DisplayName &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TotalItemSize &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TotalDeletedItemSize &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProhibitSendQuota &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;QuotaPercent 
Yarek Ostaniewicz &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;21391447449 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4078347 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;199 
Henry Zyborowicz &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9122279993 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;612592 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;85 
Anna Kasperska &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8622971671 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;46421635 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;81 
Voytek Kaniewski &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9413027487 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;684775 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11811160064 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;80 
Carol O'Connor &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8297964369 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1162302 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;77 
Lukasz Kaniewski &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7844703997 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1833290 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;73 
Agnieszka Burkiewicz &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5600296574 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7322530 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8589934592 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;65 
Heather Maher &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13048108982 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;593273 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;21474836480 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;61 
Jacek Wasielak &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6440912019 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;125600 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;60 
Pawel Kaniewski &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4277592304 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;379555 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;40 
Lindsay Gotthold &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3812889067 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;488374 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;36 
Tom Cieslik &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3521166152 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;501751 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;33 
Agnieszka Zerdecka &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3528278995 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;33 
Jeff Petro &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3312792180 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;31 
Adam Tulik &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3341756482 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;311921 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;31 
Dorothy Lukasz &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3186659394 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;371892 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10737418240 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;30
</div>

<div>
the below allows me to get what i needed just need to convert it to look at all mailboxes instead of one 
 

<pre><code class="code-10 nolinks" id="code-20-42060363-1"># Get-MailboxQuota.ps1
# Script for showing mailbox size and quota
 
# Exit the script if username is not found
If ($args[0] -eq $null) {
 Write-Host &quot;Error: No user specified&quot; -ForegroundColor &quot;Red&quot;
 break
}
 
# Get the username from the command line argument
$username = $args[0]
 
# Get the mailbox, break if it's not found
$mb = Get-Mailbox $username -ErrorAction Stop
 
# Get the mailbox statistics
$mbstats = Get-MailboxStatistics $username
 
# If the mailbox is using the database quotas then read them, otherwise read them from the mailbox
If ($mb.UseDatabaseQuotaDefaults -eq $true) {
 $quota = (Get-MailboxDatabase -Identity $mb.Database).ProhibitSendQuota.Value.ToMB()
} else {
 $quota = $mb.ProhibitSendQuota.Value.ToMB()
}
 
# Get the mailbox size and convert it from bytes to megabytes
$size = $mbstats.TotalItemSize.Value.ToMB()
 
# Write the output
Write-Host &quot;Mailbox: &quot; $mb.DisplayName
Write-Host &quot;Size (MB): &quot; $size
Write-Host &quot;Quota (MB):&quot; $quota
Write-Host &quot;Percent: &quot; ($size/$quota*100)
Write-Host
</code></pre>
</div>

<div>
My guess is that you will get those errors on mailboxes that have a quota set to unlimited (default). &nbsp;This would include user, room, equipment and shared mailboxes. 
 
You don't need to edit line 34. &nbsp;Just run the command like what is below to get all mailboxes that have used 30% or more of their defined quota. &nbsp;Because my lab is so small, I checked for those larger than 0.01 percent. 
 

<pre><code class="code-1 nolinks" id="code-20-42060372-1">TGet-MailboxSizeQuota.ps1 30
</code></pre>
 
Here is the link to the reference script Tom provided you... 
 

<ul>
<li><a href="http://blog.haake.nu/2015/01/exchange-2013-mailbox-quota-usage-and.html" rel="ugc">Exchange 2013 mailbox quota usage and size report</a></li>
</ul>
</div>

<div>
The errors can be disregarded. Did you review the output in the report?
</div>

<div>
<blockquote>
awesome exactly what i needed i try to export-csv and it gives me an error any help with that would be appreciated.
</blockquote>
You just said that before so I assume You've tested script and was working for you. 
 
Than You've asked how to send report to CSV file so I've told you how. 
I've tested all and It is working. 
 
If is not working for you maybe you just put some modification to script that it not supposed to be there. 
 
Try copy script again. 
 
@Todd. 
I have few users with Unlimited quota set and script still working, so this is not a issue.
</div>

<div>
Hi, 
 
Apologize for the dealy, 
please try below script, 
 

<pre><code class="code-10 nolinks" id="code-20-42061429-1">$obj =@()
$users = get-mailbox -resultsize unlimited
Foreach ($user in $users)
{
	$mx = Get-Mailbox -Identity $user
	$mxs = Get-MailboxStatistics -Identity $user
	$properties = @{Displayname = $mx.displayname
			 Currentsize = $mxs.totalitemsize 
			 Totalsize = $mx.prohibitsendreceivequota
			 #calc = (Totalsize *100)/Currentsize
			 #Res = 100 - (calc)
			}
	$obj += new-object -typename psobject -property $properties
	
} 
$obj | select-object Displayname,Currentsize,Totalsize | Export-csv &quot;C:\ee.csv&quot; -notypeinformation
</code></pre>
 
Thanks
</div>

<div>
@dinesh the export doesnt work it overwrites the same line in the export over and over :(
</div>

<div>
Hi, 
It worked for me, could you please past your code here. 
Last line should be out of braces.
</div>

<div>
$obj =@() 
$users = get-mailbox -resultsize unlimited 
Foreach ($user in $users) 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mx = Get-Mailbox -Identity $user 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mxs = Get-MailboxStatistics -Identity $user 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$properties = @{Displayname = $mx.displayname 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;Currentsize = $mxs.totalitemsize 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;Totalsize = $mx.prohibitsendreceivequota 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;#calc = (Totalsize *100)/Currentsize 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;#Res = 100 - (calc) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$obj += new-object -typename psobject -property $properties 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
} 
$obj | select-object primarysmtpaddress,Displayname,Currentsize,Totalsize | Export-csv &quot;C:\temp\ee.csv&quot; -notypeinformation
</div>

<div>
Please paste your output too
</div>

<div>
CVS ERRORS 
 
&quot;primarysmtpaddress&quot;,&quot;Displayname&quot;,&quot;Currentsize&quot;,&quot;Totalsize&quot; 
,&quot;ZZ_Admin &quot;,&quot;493210B&quot;,&quot;unlimited&quot; 
,&quot;ADMIKN&quot;,&quot;1015040049B&quot;,&quot;1086MB&quot; 
 
_______________________________WINDOW ERRORS___________________________ 
validation errors have been encountered: 
WARNING: Object cannot be saved because its ExchangeVersion property is 0.20 (15.0.0.0), which is not supported by the current version 0.1 (8.0.535.0). You will need a later version of Exchange. 
WARNING: The value of property 'RecipientTypeDetails', 549755813888, is not defined in the Enum type 'RecipientTypeDetails'. 
WARNING: An unexpected error has occurred and a Watson dump is being generated: Index was outside the bounds of the array. 
Get-MailboxStatistics : Index was outside the bounds of the array. 
At C:\Users\admin\Desktop\M4.ps1:6 char:30 
+ &nbsp; &nbsp; $mxs = Get-MailboxStatistics &lt;&lt;&lt;&lt;&nbsp; -Identity $user 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [Get-MailboxStatistics], IndexOutOfRangeException 
&nbsp; &nbsp; + FullyQualifiedErrorId : System.IndexOutOfRangeException,Microsoft.Exchange.Management.MapiTasks.GetMailboxStatistics
</div>

<div>
I'm not sure why script I've provided is not working for you. For me is perfectly fine 
 
are you using entry parameter for quota ? 
 

<blockquote>
C:\Users\adm\desktop\MailboxSizeQuota.ps1:51
</blockquote>
 
If Yes it should be like 
 
C:\Users\adm\desktop\MailboxSizeQuota.ps1 51 &nbsp; (space between ps1 and number) 
 
Or you can modify line 34, put number 1 and run script without parameters 
 
GO to Powerschell 
cd\ 
cd Users\adm\desktop 
 
.\MailboxSizeQuota.ps1 
 
ENTER
</div>

<div>
i change line 34 to 1 and the below error continues without an output csv 
 
 
Attempted to divide by zero. 
At C:\Users\adm\Desktop\MailboxSizeQuota.ps1:63 char:5 
+ &nbsp; &nbsp; $usr_quota_percentage = [INT]((($usr_mailboxstats_totalitemsize + 
$usr_mailb ... 
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
~~~ 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], RuntimeException 
&nbsp; &nbsp; + FullyQualifiedErrorId : RuntimeException
</div>

<div>
So there is not any list mailboxes you get and any suggestion which mailbox is causing problem ? 
It looks like you have mailbox with 0 emails so script can't divide by 0
</div>

<div>
i assume that is correct the export is zero bytes :( and keeps looping the same error message
</div>

<div>
There is a math in script: 
 
$usr_quota_percentage = [INT]((($usr_mailboxstats_totalitemsize + $usr_mailboxstats_totaldeleteditemsize) / $usr_quota)*100) 
It looks like in your network one or more mailbox usr_quota = 0 after conversion to Integer 
 
[INT64]$usr_quota = [convert]::ToInt64(((($usr_mailbox.ProhibitSendQuota.ToString().split(&quot;(&quot;)[-1]).split(&quot;)&quot;)[0]).split(&quot; &quot;)[0]-replace '[,]','')) 
 
In that case it will be error since you can't / 0 
 
You can try replace line 63 &nbsp;/ $usr_quota by some numner, let say 1000 
 
$usr_quota_percentage = [INT]((($usr_mailboxstats_totalitemsize + $usr_mailboxstats_totaldeleteditemsize) /1000)*100)
</div>

<div>
Best solution provided. No more other questions from author
</div>

<div>
<div class="content wysiwyg-content">
Hi, 
 
I am trying to get all an exchange mailbox report for all mailboxes and their quota set configuration and what percentage left to reach quota. 
 
any help is appreciated 
 
Regards, 
J
</div>
</div>

Hi,

I am trying to get all an exchange mailbox report for all mailboxes and their quota set configuration and what percentage left to reach quota.

any help is appreciated

Regards,
J

Exchange Mailbox Report Total Size and Quota Reach Percentage

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.