Powershell: Getting Mailbox Sizes in PowerShell

Obtain a list of mailboxes (with details including item count, size, logon info, etc.). Below are two reporting variants (out-gridview and format-table).

Get-MailboxServer | Get-Mailbox -Results Unlimited | Get-MailboxStatistics|
 where {$_.ObjectClass –eq “Mailbox”}|
 Select-Object -property `
 @{label="User";expression={$_.DisplayName}},
 @{label="Mailbox Database";expression={$_.Database}},
 @{label="Mailbox Server Name";expression={$_.ServerName}},
 @{label="Total Size (MB)";expression={$_.TotalItemSize.Value.ToMB()}},
 @{label="Total Items";expression={$_.ItemCount}},
 @{label="Storage Limit";expression={$_.StorageLimitStatus}},
 @{label="Total Deleted Item Size (MB)";expression={$_.TotalDeletedItemSize.Value.ToMB()}},
 @{label="Deleted Items";expression={$_.DeletedItemCount}},
 @{label="Last Logged On";expression={$_.LastLoggedOnUserAccount}},
 @{label="Last Logged On Time";expression={$_.LastLogonTime}},
 @{label="Last Logged Off Time";expression={$_.LastLogoffTime}},
 @{label="Is Quarantined";expression={$_.IsQuarantined}} | 
 Out-GridView

No comments:

Post a Comment