list email users (E2k7)

<disclaimer – this is not my work – I horked it from somewhere, I am just sharing it>

Do you have a lot of users? Do you wish you could list them by size, name, number of items?

Get-MailboxStatistics | sort-object -descending totalItemSize | select -first 5 | ft DisplayName, @{expression={$_.totalitemsize.value.ToMB()};label=”Mailbox Size(MB)”}, itemcount, lastlogontime

Change the “select -first 5″ to whatever number you like.

E2k7 Powershell commands 1

 display mailbox stats by name, item count, total size, host server

 I get asked how to view simple stats in Exchange 2007 – like which are the biggest mailboxes? Or, who has the greatest number of items.

Here are a few powershell commands you can use.   

Get-MailboxServer | Get-MailboxStatistics | select displayname,itemcount,totalitemsize | ConvertTo-HTML | Out-File C:\Test.htm 

get-mailbox | get-mailboxstatistics | FT displayname, itemcount, totalitemsize, servername 

get-mailbox | get-mailboxstatistics | select-object displayname,itemcount,totalitemsize | export-csv c:\mailboxsurvey2.csv 

get-mailbox jweber | get-mailboxstatistics | select-object displayname, itemcount, totalitemsize, lastloggedonuser, lastlogontime, lastlogofftime, servername, databasename | export-csv c:\exchangereports\userstats.csv