(HOW TO GET MAILBOX SIZES)
Get-MailboxStatistics -Server e-mail | Select DisplayName, ItemCount, TotalItemSize | Sort-Object TotalItemSize -Descending
(PRE-REQUIREMENTS)
1.) Open Exchange Management Shell
2.) New-ManagementRoleAssignment –Role "Mailbox Import Export" –User Administrator
3.) Close EMS and Reopen
4.) Export Exchange Users list to a Tab Delimited .txt file.
5.) Formula for Excel: ="New-MailboxExportRequest -Mailbox "&B2&" -FilePath \\e-mail\pst\"&B2&".pst"
(EXPORT ALL MAILBOXES TO PSTs)
New-MailboxExportRequest -Mailbox user1 -FilePath \\e-mail\pst\user1.pst
New-MailboxExportRequest -Mailbox user2 -FilePath \\e-mail\pst\user2.pst
New-MailboxExportRequest -Mailbox user3 -FilePath \\e-mail\pst\user3.pst
New-MailboxExportRequest -Mailbox user4 -FilePath \\e-mail\pst\user4.pst
New-MailboxExportRequest -Mailbox user5 -FilePath \\e-mail\pst\user5.pst
(HOW TO GET MAILBOX EXPORT REQUESTS)
Get-MailboxExportRequest