And frankly from a reporting standpoint I prefer Powershell here. I could generally give a rat's ass what any particular mailbox size is; but I do care what the list is of all mailboxes over a certain size. When you have 96 servers averaging 4 data stores each, compiling this information manually was a PITA. Now would it have been nice for them to build a toolbox tool to generate these reports? Yep. But unless I was working in a small environment, I was always pissed at how cumbersome it was to collect the data (and how difficult it was to write a script to automate it).
I won't apologize for Microsoft, they took a step back. However, they did build a foundation for taking a large step forward if they take the time to build a better tool (or here's a shocking possibility... open the **&(#@ #&!)*ing toolbox to 3rd party vendors to insert tools). I will say I don't miss the right-click | grant new permission model at the store level in the least and even doing it from powershell only (and having to find the right syntax) is preferable in every way. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Harris Posted At: Wednesday, January 16, 2008 10:04 AM Posted To: swynk Conversation: PowerShell Subject: RE: PowerShell Hi Robert, The reason you can't see the mailbox size in the GUI console is that it requires a connection to each server whereas all of the Mailbox information that you can see in the console comes from AD. I understand the pain of going to two different data sources, but even so I fought for a long time to have the mailbox size (and other stats) included in the GUI. As you can see I lost. Anyway - the oneliners to get the data you want are relatively short - you don't have to specify something for all of the possible parameters of the cmdlet. If you have a single server you just need to do the following: Get-MailboxStatistics | ft DisplayName,TotalItemSize If you want it sorted: Get-MailboxStatistics | sort TotalItemSize -desc | ft DisplayName, TotalItemSize If you have multiple mailbox servers: Get-MailboxServer | Get-MailboxStatistics | sort TotalItemSize -desc | ft DisplayName,TotalItemSize Only show mailboxes over a particular size: Get-MailboxServer | Get-MailboxStatistics | where {$_.TotalItemSize -gt 1mb} | sort TotalItemSize -desc | ft DisplayName,TotalItemSize (Notice - you don't have to specify the size in bytes, PS will automatically translate 1mb into the appropriate number of bytes) Chris -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of McCready, Robert Sent: Wednesday, January 16, 2008 10:39 AM To: Exchange Discussions Subject: PowerShell Mercy, I hate Exchange 2007 PowerShell. This crap was much simpler with Exchange 2003. Can someone tell me the command to see... 1. The current mailbox sizes of all users. 2. The current mailbox size of users over xx size? With Exchange 2003, all I had to do was open System Manager and click on the column to sort by size! Now I probably have to type something dorky in like.... Get-mailboxstatistics -idenity -server -database -rubyourbelly -8675309 {_.usestoragequotadefaults) | "could this be any more cumbersome" -cheesy poofs | FL _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/read/?forum=exchange To subscribe: http://e-newsletters.internet.com/discussionlists.html/ To unsubscribe send a blank email to [EMAIL PROTECTED] t.com Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/read/?forum=exchange To subscribe: http://e-newsletters.internet.com/discussionlists.html/ To unsubscribe send a blank email to [EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/read/?forum=exchange To subscribe: http://e-newsletters.internet.com/discussionlists.html/ To unsubscribe send a blank email to [EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
