Link to home
Start Free TrialLog in
Avatar of OCUW
OCUWFlag for United States of America

asked on

Is it possible to get an Exchange 2010 (Powershell?) report which outlines users Online Archive mailbox size?

I'm trying to present management with a report of some sort that shows how much space each user is occupying in their Online Archive (exchange 2010). I've found countless reports which accomplish the above in regard to the Mailbox size (.csv or .htm dumps etc.), but I need one for the Online Archive specifically. Also, I'd really like to be able to do this with one script\command, instead of having to run a command against each mailbox individually. Thanks!
Avatar of FDiskWizard
FDiskWizard
Flag of United States of America image

Do you need per user, or just overall numbers?

I just stumbled on this powershell report script... but have not used.
It includes average Archive mailbox sizes in its reporting.
http://www.stevieg.org/2011/06/exchange-environment-report/

Really nice looking report.
if you add the -Archive parameter to the Get-MailboxStatistics cmlet it will get you the stats for the online archive
Avatar of OCUW

ASKER

FDiskWizard:

I need per user. That's a neat script, though. I'll keep it handy

Akhater:

Thanks, but I'm aware of how to do it individually. I need a method of running it against all the users in my org.
ASKER CERTIFIED SOLUTION
Avatar of Akhater
Akhater
Flag of Lebanon image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of OCUW

ASKER

I was able to piece together the following (from a few sources).

Get-Mailbox | Get-MailboxStatistics  -archive | Sort-Object TotalItemSize -descending |Select-Object DisplayName,ItemCount,@{name="MailboxSize";exp={$_.totalitemsize}} -first 100 | Convertto-Html | out-File C:\ArchiveSizeReport.htm