• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1391
  • Last Modified:

What's the cmdlet for exporting mailbox sizes including OU


I need a cmdlet with exchange power shell that exports mailboxes size and ProhibitSendQuota for a specified OU in csv file and the result be  organized from the large mailbox size to the small i tried the below command but when i export it to csv file it comes with bad data ( displays the display name just random numbers and characters and everything else is not displayed )

get-mailbox -organizationalunit "precast factory" | get-mailboxstatistics | ft Displa
yName, TotalItemSize, ItemCount | export-csv "c:\report.csv"

so please someone provide me the right cmdlet that meets the above request

Thanks in advance
1 Solution
Try following
get-mailbox -organizationalunit "precast factory" | get-mailboxstatistics | select DisplayName, TotalItemSize, ItemCount | export-csv "c:\report.csv"

Open in new window

Get-Mailbox -ResultSize Unlimited | where {$_.OrganizationalUnit -eq 'domain\OU'}| Format-Table Displaynamealias,issuewarningquota,prohibitsendquota,prohibitsendreceivequota, @{Label='Size(MB)';expression={$mbx=get-mailboxstatistics -identity $_;$mbx.totalitemsize.value.toMB()}} >c:\GroupMailboxquota_1.csv

Open in new window

hussein-AlrajehAuthor Commented:
the answer wasn't complete cause no send prohibit or receive on the command
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now