Get a mailboxsize and last logontime report

The Exchange Management Console for Exchange 2007 or 2010 doesn’t have a reporting functionality. If you want to have a report on the mailboxes within your organization you will need to use the Exchange Management Shell.

When you want to report the mailbox size and the last logon time for all the mailboxes in your organization, you can use the following commandline.

get-mailbox -resultsize unlimited | Get-MailboxStatistics | sort -property lastlogontime -descending | ft displayname, alias, server, totalitemsize, storagelimitstatus, lastlogontime  >c:\export.csv

If you need more information in the outputfile, you can add properties to the command.

 

Comments

Total
0
Shares
Leave a Reply

Your email address will not be published. Required fields are marked *

Previous Post

Exchange 2010 & Powershell commands part 1

Next Post

Missing commandlets in Exchange 2010 SP1?

Related Posts
Total
0
Share