Michael Leonard
asked on
need assistance with a powershell script to export out "online archive" mailbox sizes
hello, we are running into an error when trying to export out a size report on all online archive mailboxes:
error:
here is the script we are running:
many thanks,
S.
error:
Sending data to a remote command failed with the following error message: The total data received from the remote clien
t exceeded allowed maximum. Allowed maximum is 524288000. For more information, see the about_Remote_Troubleshooting He
lp topic.
here is the script we are running:
Get-Mailbox -Archive -ResultSize Unlimited | Get-MailboxStatistics -Archive | Select DisplayName,StorageLimitStatus,@{name="TotalItemSize (MB)";expression={[math]::Round((($_.TotalItemSize.Value.ToString()).Split("(")[1].Split(" ")[0].Replace(",","")/1MB),2)}},@{name="TotalDeletedItemSize (MB)";expression={[math]::Round((($_.TotalDeletedItemSize.Value.ToString()).Split("(")[1].Split(" ")[0].Replace(",","")/1MB),2)}},ItemCount,DeletedItemCount | Sort "TotalItemSize (MB)" -Descending | Export-Csv "C:\All Archive Mailboxes.csv" -NoTypeInformation
many thanks,
S.
One other suggestion is like one from this article: Exchange Massive Search and Destroy & Quota control.
Basically you could limit the Get-Mailbox command to Databse or Server using resepctive parameters, or avoid pipelining by creating a loop (see an example in the above article).
Basically you could limit the Get-Mailbox command to Databse or Server using resepctive parameters, or avoid pipelining by creating a loop (see an example in the above article).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
worked perfect! thank you Subsun
http://technet.microsoft.com/en-us/library/hh849726.aspx