FT or Format-Table doesnt work well with Export-CSV.

Use SELECT-OBJECT instead of FT.

Get-MailboxStatistics -Database “DatabaseName” | Sort -Property TotalItemsize -desc| Select-Object DisplayName, LastLoggedOnUserAccount, ItemCount, @{expression={$_.totalitemsize.value.ToMB()};label=”Size(MB)”}, LastLogonTime, LastLogoffTime | Export-CSV test.csv

Get-MailboxStatistics -Server ‘SW-EXCH’ | where {$_.ObjectClass -eq “Mailbox”} | Sort-Object TotalItemSize -Descending | ft @{label=”User”;expression={$_.DisplayName}},@{label=”Total Size (MB)”;expression={$_.TotalItemSize.Value.ToMB()}} -auto >> “c:\mailbox_size.txt”

I don’t hate Powershell, but I am annoyed that there doesn’t seem to be a consistent and complete source of information on it. A list of commands is available anywhere (including in Powershell itself), but a complete listing of the various switches, options, and output syntax is not available anywhere that I’ve been able to find. It’s a long painstaking process trying to figure out how to make it do what you want.

If I worked in a large company with enough staff to allow us the luxury of having someone sit around half the time figuring all this stuff out, I’d use it more. As it is, if it weren’t for sites like this one, with folks able to take the time to learn this very complicated and poorly documented scripting language (and willing to share), I’d likely never use it.

Life’s too short.

Thanks to Paul (and his readers), I can find it and use it. But I likely will never learn it…

Boooo for PowerShell. Sorry, just how I feel.

I’m one of those 80’s folks, so have always been very comfortable with scripting. I also have to disagree on Powershell being an advance. It is lousy! Syntax is not consistent. Commands are more likely to be “not recognized” than to actually work, because of the way modules are loaded in and out. Generating simple information requires piping so many different commands together it is ridiculous.

Nice try by Microsoft, but they need to scrap it and start again. Take a hint old scripting languages to get it right. And while they are at it, why not keep the GUI full-functional and also provide solid scripting capability?

Thanks very much for your priceless support, you´re a star!

Your articles never let me down.

Keep it up sharing your valuable knowledge.

Cheers

After 10 years i can honestly say i have not stopped taking on new challenges, learning new technologies, new tools that make my life easier. Before Powershell and EXCHANGE i was using Oracle Solaris and a simple mail server which has pop, imap and smtp. Everything was done via a CLI. I still prefer this as it has more functionality, more options than these GUI products contain.

Serious the new generation of IT are like script kiddies out there whom need someone to code the program in a way they can do everything in 1 or 2 clicks of the mouse. Embarassing.

This script works very well actually;
I have found that:

Get-MailboxDatabase | Get-MailboxStatistics | Sort totalitemsize -desc | Export-CSV C:mailboxes.csv

Works Quite Well for those whom need to create some report for their higher up or senior in regards to mailbox size management. It works in Exchange 2010 SP1, 2, and 3. Works in Server 2012 R2 as well as previous 2012 and 2008 R2. If you can’t get this command to work your exchange server has more problems than you can imagine and maybe you should be looking in eventvwr or any other tools you have for monitoring and managing the server.

Just wanted to write this up because every time i enter a forum where someone posts a working script there are a bunch of amateur IT folks who try to claim it doesn’t work for them. It isn’t the script, its the person who doesn’t know what they are doing but decide to do it anyways not knowing the consequences, these are the SAME IT Folks who reduce the number of permanent position jobs out there because they *FUCK* up the previous job so the employer does contract work only thereafter.

Thank you,

Proxy-Si-
(IRC User – Botnet 50K Class approaching 75K – Well known IT Administrator in Toronto)