Extracting Mailbox data
In exchange2k3 I could export all users and their mailbox size and storage group to csv, how do I do it in Exchange2k7?? Thanks
July 17th, 2007 5:23am
get-mailboxstatistics | ft displayname,storagegroupname,totalitemsize
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2007 6:08am
I think to export to csv you can use | export-csv c:\mblist.csv on the end of the command above.
Or | out-file c:\mblist.txt
If the list wraps you may want to add -wrap to the command so that it will include everyting
get-mailboxstatistics | ft displayname,storagegroupname,totalitemsize -wrap | out-file c:\mblist.txt
July 17th, 2007 6:16am
Thanks BB
When I run the command I get the usernames and the storagegroup is blank and the item size is blank.... What am i missing??
Thanks S
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2007 10:35pm
Try running the command without any options, and see if username is coming up blank.
get-mailboxstatistics | fl
This command should return every posible value ina list format.
Run this while logged into the exchange server you would like to generate this report for.
Make sure that you are using the exchange management shell not the normal PS.
July 18th, 2007 3:04am