Hello,

I am wondering if there is any way to output the mailboxstats of all users on a mail server by either username or Alias. I have been doing it by displayname, which is fine, but when I run the displayname against an A/D query to see which account is disabled/enabled, my output of names is longer than what I originally started with. This is because we always have employees that leave the company as employees and come back as contractors, and they get a new A/D account where the display name is usually the same. Any assistance is very much appreciated

My Code

Get-mailboxserver -id: |get-mailboxstatistics|fl displayname, itemCount

Get-mailboxserver -id: |get-mailboxstatistics|fl , itemCount

This code provides a blank continous column under Alias

Thanks..

try

get-Mailbox| get-MailboxStatistics

get-mailboxstatistics doesn't have any such members:

get-mailboxstatistics|get-member *smtp*,*alias* <--returns nothing

Maybe there's a better way, but this should work:

[PS] >get-mailbox|ft alias,@{l="database";e={$_|get-mailboxstatistics|select database}}

Now, that could make a very long command to add everything you're looking for...

Piping to select will wrap the database coulmn in array, it shows like:

alias   database
------    -------------
user   @{...}

Try this:

PS > get-mailbox | ft alias, @{l="database";e={ (get-mailboxstatistics $_).database}}

I was able to get the output I was desiring with the following:

get-mailbox -Server "MYE2K7SERVERNAME" | ft alias, *SMTP*, @{l="Database";e={ (get-mailboxstatistics $_).database}}, @{l="DisplayName";e={ (get-mailboxstatistics $_).Displayname}}, @{l="StorageLimitStatus";e={ (get-mailboxstatistics $_).StorageLimitStatus}},@{l="ItemCount";e={ (get-mailboxstatistics $_).ItemCount}},@{l="TotalItemSize(MB)";e={ (get-mailboxstatistics $_).TotalItemSize.Value.ToMB()}} >f:\mailbox_exports\E2007Mailboxes.csv

However, I've got a couple of challenges yet to figure out:
1. The output is compressing the longer value columns with ellipses {...} in the output file:


Alias PrimarySmtp Database DisplayNam StorageLim ItemCount TotalItemS
Address e itStatus ize(MB)
----- ----------- -------- ---------- ---------- --------- ----------
LOGONID Allan.Us... SERVERNA... UserN, ... BelowLimit 1202 54

How can I format it to output the complete contents of the field?

2. Is there an easy way to name the export file with a date stamp?

Thanks for everyone's help!

I would go this way:

1. You have to many get-mailboxstatistics calls, you can use one call per user.
2. Use select-object instead of format-table and then pipe to export-csv
3. If you need to export output to csv don't use any format-* at the end of the pipeline, let powershell deserialize the output for you.

$Database = @{n="Database";e={ $stats.database }}
$DisplayName = @{n="DisplayName";e={ $stats.Displayname }}
$StorageLimitStatus = @{n="StorageLimitStatus";e={ $stats.StorageLimitStatus }}
$ItemCount = @{n="ItemCount";e={ $stats.ItemCount }}
$TotalItemSize = @{n="TotalItemSize(MB)";e={ $stats.TotalItemSize.Value.ToMB() }}

get-mailbox -server "MYE2K7SERVERNAME" | foreach {
 $stats = get-mailboxstatistics $_
 $_ | select alias, *SMTP*,$Database,$DisplayName,$StorageLimitStatus,$ItemCount,$TotalItemSize
} | export-csv f:\mailbox_exports\E2007Mailboxes.csv -nti