This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 31%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Hi,
Please help me export all EXO archive mailboxes size report.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 74%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Use the Get-MailboxStatistics cmdlet with the -Archive switch to get the data.
How you "report" that data depends, I suppose, on what parts of the data you're interested in and in what format you want the data presented.
I am looking for UPNs or Primary SMTP address fields along with size and item count in the exported file.
You'll find those properties on the mailbox object (Get-Mailbox) and the AD user object (Get-User), both cmdlets are part of the Exchange cmdlets.
I know these properties are part of EXO get-mailbox command, but i want to export archive status for each mailbox, how can i export the report which should also include user details like primary SMTP or UPN.
You're making progress! You've identified the data points you want to extract from each mailbox and the PowerShell cmdlets to use in getting those data.
What you still haven't identified is what kind of presentation you want for this "report". Should it be in HTML format (ConvertTo-HTML)? Comma Separated Value format (Export-CSV)? Just display on the console as text (Format-Table)? Or in a grid view (Out-GridView)? Or is it perhaps in some other format?
Asking for help is one thing. Asking for someone to create a solution is another . . . especially when the specifics aren't stated.