Quick PowerShell Tip using Get-MailboxStatistics

re: Quick PowerShell Tip using Get-MailboxStatistics

Joel Stidley — Wed, 05 Aug 2009 21:27:55 GMT

Chris, you might be able to use the Quest AD PowerShell or perhaps the Windows 2008 R2 cmdlets. Off the top you might be able to run: get-QADUser -SearchRoot 'company.com/UsersOU' | Get-MailboxStatistics | where-object {$_.LastLogonTime -lt '12/23/2007'} | sort-object DatabaseName, TotalItemSize,LastLogonTime | format-table DisplayName, @{expression={$_.TotalItemSize.Value.ToMB()};label="TotalItemSize(MB)"}, LastLogonTime, DatabaseName

you would do this for each OU, there are other things you could do to customize that.

re: Quick PowerShell Tip using Get-MailboxStatistics

chris.trotter@gmail.com — Wed, 29 Jul 2009 17:47:56 GMT

I am interested in using a script like this, sorting by OU and then by TotalItemSize, but I cannot manage to make it work. Suggestions?

re: Quick PowerShell Tip using Get-MailboxStatistics

Joel Stidley — Wed, 23 Jul 2008 19:02:21 GMT

ckemppel,

Which specific attributes are you looking to add?

re: Quick PowerShell Tip using Get-MailboxStatistics

ckemppel — Wed, 23 Jul 2008 17:39:06 GMT

Hi Joel, the question asked is the same question I have; While your script addresses part of the question it does not achieve the required result of merging the "get-mailbox "and "get-mailboxstatistics" output into a single table so that the Alias and any other parameters desired from the get-mailbox command are available, have you had any further progress on this?

They say it better than I can...

Dougs Blog >> Exchange Server in the field — Mon, 02 Jun 2008 08:23:15 GMT

Just want to point you to a few blog articles I have read recently just in case your search doesn't reveal