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

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

Posted on 2013-12-12
8
307 Views
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
0
Comment
Question by:dougdog
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 19

Expert Comment

by:jss1199
ID: 39714489
change Username to Alias
0
 

Expert Comment

by:Lord_aLi112
ID: 39714492
I can confirm the username column is empty.
0
 
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.

Will.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

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

Expert Comment

by:Lord_aLi112
ID: 39714536
does not work with alias neither
0
 

Author Comment

by:dougdog
ID: 39714541
can confirm alias does not work
0
 
LVL 53

Accepted Solution

by:
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.

http://get-exchange.blogspot.ca/2009/03/did-you-ever-needed-to-supply-list-of.html

Will.
0
 

Author Comment

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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

A brief introduction to what I consider to be the best editor for PowerShell.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…

809 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