Hi,

Try this command:

Get-Mailbox -ResultSize Unlimited | Select-Object DisplayName, OrganizationUnit, Database, @{label="TotalItemSize(MB)";expression={(Get-MailboxStatistics $_).TotalItemSize.Value.ToMB()}}, @{label="ItemCount";expression={(Get-MailboxStatistics $_).ItemCount}}, @{label="LastLogonTime";expression={(Get-MailboxStatistics $_).LastLogonTime}} | Export-Csv "C:\UserMailboxReport.csv"

I tests it in may lab and it works well.

Best Regards.

Hi,

I am looking for a way to get complete info about usage on my exchange server,  i have 34 diffrent organization units with one or more user under them.

I use the bellow command in ps to get info about display name, total item size, item count, database and last logon time.

But i need more info, like either organization unit name or logon name, too see witch organization it belongs to, is that possible with the bellow command ? or do i need all new command?

Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Select DisplayName,TotalItemSize,ItemCount,Database,LastLogonTime | Sort TotalItemSize -Descending | ConvertTo-Html -Title "Mailbox Stats"| Out-file "C:\Reports\Data.html"

You may have to first get the output of mailboxes with email address and organization name into a csv and then run get-mailboxstatistics command to get the count.