Solved

What's the cmdlet for exporting mailbox sizes including OU

Posted on 2012-03-17
5
1,350 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
[X]
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
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 19

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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In this video we show how to create a mailbox database 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 Servers >> Data…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

730 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