getting an output erron when running the following command in PS

Posted on 2013-12-17
Last Modified: 2014-02-19

Get-Mailbox -ResultSize unlimited | Get-MailboxStatistics | Sort -Property TotalItemsize -Descending | Format-Table DisplayName, StorageLimitStatus, TotalDeletedItemSize, ItemCount, @{expression={$_.totalitemsize.value.ToMB()};label=”Size(MB)”} > c:\Exchangereports\emailreport.CSV


Sending data to a remote command failed with the following error message: The total data received from the remote client exceeded allowed maximum. Allowed maximum is 524288000. For more information, see the about_Remote_Troubleshooting Help topic.

    + CategoryInfo          : OperationStopped: (system.Manageme...pressionSyncJob:PSInvokeExpressionSyncJob) [], PSRe
    + FullyQualifiedErrorId : JobFailure

Dose anyone knwo how to fix this error or is there a different command I cna use to get the informaiton?

Exchange server information

Exchange 2010 sp3 ru2
Question by:SEHC
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 15

Expert Comment

ID: 39724797
Powershell has a hard limit of 524,288,000 bytes returned from a query.
The value for the powershell limit is in web.config file.
To increase the limit, increase the value and then recycle the app pool or perform an iisreset.
In addition, The memory requirement can be reduced by limiting the query to 1000 mailboxes at a time using the where-object to filter those mailbox.

Author Comment

ID: 39724803

where is the web.config file located because the one in the wwwroot does not have the information in there to be changed.


Author Comment

ID: 39724829
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

LVL 15

Expert Comment

ID: 39724832
Usually it is in

C:\Program Files\Microsoft\Exchange Server\V14\ClientAccess\ecp\web.config

Author Comment

ID: 39724834
thanks let me take a look at that and I will let you knwo if it worked
LVL 40

Accepted Solution

Subsun earned 500 total points
ID: 39726391
Try this script instead of doing all process in pipeline...
$mailboxs = Get-Mailbox -ResultSize unlimited
$(Foreach ($mailbox in $mailboxs){ 
 $mailbox | Get-MailboxStatistics |
  Select DisplayName, StorageLimitStatus, TotalDeletedItemSize, ItemCount, @{expression={$_.totalitemsize.value.ToMB()};label=”Size(MB)”}
})| Sort -Property "Size(MB)" -Descending | c:\Exchangereports\emailreport.CSV

Open in new window


Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to:…
Suggested Courses
Course of the Month8 days, 18 hours left to enroll

617 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