Powershell – Exchange – get age range of items using Powershell

exchangepowershell

We are going to be implementing personal archives for Exchange in our organization. For us to get a good grasp on how much space is needed, we need to get an idea of the age of items that we currently have. Is it possible to have a powershell script that tells me the total size and number of items given certain date ranges of all mailboxes in all databases?

What I'd like to have is the 1) number of items, 2) total size of times (GB) – all grouped by date ranges (Less than 15 days, 15-30 days, 30-60 days, 60-90 days, more than 90). Another possibility would be to have it also grouped by mailbox database

Best Answer

For anyone coming across this page while doing a search, a much more complete solution is detailed at http://gsexdev.blogspot.com/2012/10/reporting-on-item-age-count-and-size-in.html

Related Solutions

Powershell – How to get AD users from a list of Exchange 2003 mailboxes

Without seeing your scripts it's difficult to give you a "turn key" solution. You'll probably be able to match up user accounts to mailboxes by doing an LDAP search against the msExchMailboxGuid attribute, depending on whether or not your mailbox size script can return that. That GUID will disambiguously pair a mailbox and AD user account across your entire Exchange organization.

Powershell – Using Powershell to archive mailboxes before certain date

If you have Exchange Server 2007 SP1, you can use the Export-Mailbox cmdlet, with the -DeleteContent flag and without a target, to simply delete to email items that otherwise would have been exported:

Get-Mailbox | Export-Mailbox -EndDate (Get-Date).AddDays(-90) -DeleteContent

In the example, all items in all folders, from before 90 days ago, will be deleted. You'll need to have FullAccess rights on each mailbox you perform this operation on.

To exclude certain folders, like Contacts or Calendar, use the -ExcludeFolders flag, like this:

Export-Mailbox -ExcludeFolders "\Contacts","\Calendar" -DeleteContent

Best Answer

Related Solutions

Powershell – How to get AD users from a list of Exchange 2003 mailboxes

Powershell – Using Powershell to archive mailboxes before certain date

Related Topic