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
Solved

What's the cmdlet for exporting mailbox sizes including OU

Posted on 2012-03-17
5
1,345 Views
Last Modified: 2012-03-20
Dears;

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
0
Comment
Question by:hussein-Alrajeh
5 Comments
 
LVL 12

Accepted Solution

by:
prashanthd earned 500 total points
ID: 37740448
Try following
get-mailbox -organizationalunit "precast factory" | get-mailboxstatistics | select DisplayName, TotalItemSize, ItemCount | export-csv "c:\report.csv"

Open in new window

0
 
LVL 18

Expert Comment

by:suriyaehnop
ID: 37740757
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

0
 

Author Closing Comment

by:hussein-Alrajeh
ID: 37743453
the answer wasn't complete cause no send prohibit or receive on the command
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This article explains how to install and use the NTBackup utility that comes with Windows Server.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In this video we show how to create an email address policy in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Mail Flow…
how to add IIS SMTP to handle application/Scanner relays into office 365.

839 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