produce a list of all exchange mailbox users sorted by size  and username

Posted on 2013-12-12
Last Modified: 2013-12-17
i want to produce a list of all exchange users and the size of their mailboxes
i want to use username instead of display name
and need them listed from the largest to the smallest
i tried using the following command

Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object UserName,TotalItemSize -First 1500 | Export-CSV mailboxes.csv

this produces the report but the username fields are empty

if i change username to displayname it works but i dont want display name i need username
Question by:dougdog
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
  • 3
  • 2
  • 2
  • +1
LVL 19

Expert Comment

ID: 39714489
change Username to Alias

Expert Comment

ID: 39714492
I can confirm the username column is empty.
LVL 53

Expert Comment

by:Will Szymkowski
ID: 39714509
Unfortunately when you are piping to get-mailboxstatistics username is not a valid a member of that cmdlet. If you pipe a command you can only display the member attributes for the last piped cmdlet. As you have listed above you are not interested in Display Name but that is the only attribute that is available for Name.

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 39714527
so how could i get a report with
username    mailbox size

Expert Comment

ID: 39714536
does not work with alias neither

Author Comment

ID: 39714541
can confirm alias does not work
LVL 53

Accepted Solution

Will Szymkowski earned 500 total points
ID: 39714548
Take a look at the following link below as it provides exactly what you are looking for. There is a little more detail than piping cmdlets. You need to create new Expressions. It is very well layed out in the document step-by-step.


Author Comment

ID: 39714558
i will see if i can figure it out what command to use

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Windows 10 came with  a lot of built in applications, Some organisations leave them there, some will control them using GPO's. This Article is useful for those who do not want to have any applications in their image (example:me).
To show how to generate a certificate request 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 >> Certificates…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

749 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