Extracting data from exchange

RedTen · 6 Mar 2009 at 11:16

Hi guys,

Im looking for some software or a means to extract mail box information from exchange.

I need basically the data that is shown in the 'Mailbox Cleanup' window.

We have a lot of users with over 50,000 messages in their inbox - we've implemented new policys but we still have users ignoring these.

Any ideas?

Cheers!

Rob7865 · 6 Mar 2009 at 12:27

What version of Exchange?
Have you looked into the Mailbox Management setup?

RedTen · 6 Mar 2009 at 12:35

Its 2003.

We are able to set limits etc on mailboxes thats not the problem. We can view total size and items but we just desperately need a break down of their different folders.

At the moment i'm having to open the users mailbox then go to mailbox cleanup and manually type up the info into a spreadsheet which obviously is a huge waste of time.

Thanks for any input

Gazzza · 6 Mar 2009 at 12:41

Promodag may have what your looking for.

Mailbox Folder Size - Find and list mailbox folders by their size and number of items.

http://www.promodag.com/products/reports/demo.aspx

iaind · 6 Mar 2009 at 13:29

You can right click any view in System Manager and export to CSV, but it sounds like you want to go one step further.
Exchange 07 gives you a bit more granular information through powershell, but I dont know if you'd even be able to go as far as this.
As Gazzza mentioned, a reporting tool may be the only way. If it were me I'd just use the normal notifications and explain to the users how to view folder sizes in Outlook. You could even customise the size warning messages to include that explanation

Rob7865 · 6 Mar 2009 at 13:45

Set up a Mailbox Management Policy in the Exchange Manager - set this to Generate Report Only (http://support.microsoft.com/kb/319188)

that should give you what your after
Rob

iaind · 6 Mar 2009 at 13:53

Aha I had forgotten about that - its been a while since I did my Exchange training!

Sorry to thread hijack but do you know if the same sort of thing is possible with 2007?

RedTen · 6 Mar 2009 at 14:02

Gazzza said:
Promodag may have what your looking for.

Mailbox Folder Size - Find and list mailbox folders by their size and number of items.

http://www.promodag.com/products/reports/demo.aspx

Awesome.

This is just the sort of thing i was after. Have a cookie

Vince · 6 Mar 2009 at 14:36

try ontrack power controls 4, you can extract from the exchange database file directly to a pst with this. It will also give you a breakdown of folders etc.

iaind · 6 Mar 2009 at 14:43

Managed to cobble this together in Powershell - Its exchange 07 only though!

$l = @()
foreach($mbx in Get-Mailbox){
$l += Get-MailboxFolderStatistics $mbx.identity | select @{n="DisplayName";e={$mbx.displayName}},FolderPath,ItemsInFolder,FolderSize}
$l

$l | export-csv C:\mailboxes.csv