As the title says, here’s a one-liner to quickly create a list of all Exchange mailboxes in an OU with mailbox size, Inbox size, Sent Items size, and the number of items in each of these folders.
|
1 2 3 4 |
Get-ADUser -filter * -SearchBase "ou=MyOffice,ou=DomainUsers,DC=MyDomain,DC=com" -Properties * | ?{ $_.msExchHomeServerName -like "*Exchange*" } | Sort-Object DisplayName | Select-Object Name,@{Name="MailboxSize"; Expression={(Get-MailboxStatistics $_.Name).TotalItemSize}},@{Name="InboxSize"; Expression={(Get-MailboxFolderStatistics $_.Name -FolderScope Inbox | Select -First 1).FolderSize}},@{Name="InboxItems"; Expression={(Get-MailboxFolderStatistics $_.Name -FolderScope Inbox | Select -First 1).ItemsInFolder}},@{Name="SentSize"; Expression={(Get-MailboxFolderStatistics $_.Name -FolderScope SentItems | Select -First 1).FolderSize}},@{Name="SentItems"; Expression={(Get-MailboxFolderStatistics $_.Name -FolderScope SentItems | Select -First 1).ItemsInFolder}} | Export-CSV -Path \path\to\file.csv |