?
Solved

What's the cmdlet for exporting mailbox sizes including OU

Posted on 2012-03-17
5
Medium Priority
?
1,368 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 1500 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

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
how to add IIS SMTP to handle application/Scanner relays into office 365.
Suggested Courses

777 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