Export exchange 2003 user mailbox information to excel csv html email

Export exchange 2003 user mailbox information to excel csv html email

This exports the user Alias, Full Name, Department, Objects ( amount of items in the mailbox), Size ( size of the mailbox ) of users on the old exchange 2003 server. In order to use the script replace <DNSEXCHANGEMB> with the target 2003 exchange server you want user information from. You must run this once for each 2003 mailbox server! It'll place the results on your desktop.

This is very usefully in planning mass user moves, as it gives mailbox size, item count and department.

For every Gig of size in mailbox it took me about 15 minutes to move a mailbox (size is in KB 1,000,000 = 1 GB)

For every 10,000 items figure 20 minutes min

Exchange moves 4 users at a time, and can queue up as many as you like

Source

#Updated removed the many year old, version and updated with the one i currently use

#run from a machine with at least powershell 3, it places the results on your desktop

#

# ***** You must run this once for each 2003 mailbox server!

gwmi -computer <DNSEXCHANGEMB> -namespace "root/MicrosoftExchangeV2" -query "select * from Exchange_Mailbox" | select MailboxDisplayname, Size, TotalItems, DeletedMessageSizeExtended, Storename, LegacyDn | Export-Csv -Path ("" + $env:USERPROFILE + "\Desktop\Exchange2003MailboxReport.csv")