export mailbox information

Question

Hi All

I am using exchange 2016 hybrid environment. we create mailboxes in onprem and migrate to online. i want to export all my mailboxes size along with Recoverable items folder size and Litigation hold status. i want to try something like the below experts guide me. can i pull the data in GB

foreach($users in Get-Mailbox -ResultSize Unlimited){$users | Foreach-Object {      
$user = $_     
$stats = Get-MailboxStatistics $user.Name  
Get-MailboxFolderStatistics  $user.Name -FolderScope RecoverableItems | Where-Object {$_.FolderPath -eq "/Recoverable Items"}            
New-Object -TypeName PSObject -Property @{          
DisplayName = $User.DisplayName  
FirstName = $User.FirstName  
LastName = $User.LastName  
userprincipalname = $User.userprincipalname  
primarysmtpaddress = $User.primarysmtpaddress  
IssueWarningQuota = $User.IssueWarningQuota          
ProhibitSendQuota = $User.ProhibitSendQuota          
ProhibitSendReceiveQuota = $User.ProhibitSendReceiveQuota         
TotalItemSize = $stats.TotalItemSize      
LitigationHoldEnabled = $User.LitigationHoldEnabled  
RecoverableItems = $User.RecoverableItems           
}   
}  
}| export-csv "c:\temp\output.csv" -NotypeInformation  

Answer 1

@Glenn Maxwell

This blog will be useful to you: Get Exchange Online Mailbox Size in GB
Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---