Hi all, We run Exchange 2007 on Win 2003 R2 machines. I need to make a list of all Exchange users and how big their mailboxes are. I'm not very proficient with the Exchange shell. Any help would be appreciated.

Use the get-mailboxstatistics cmdlet to dump that information http://technet.microsoft.com/en-us/library/bb124612(EXCHG.80).aspx example: get-mailbox -resultsize unlimited | get-mailboxstatistics | select DisplayName, TotalItemCount, TotalItemSize | export-csv -notypeinformation 'file.csv' The totalitemsize will be in bytes so you will need to do a conversion either in powershell or excel to show it in MBs.Exchange & Powershell Geek MCITP: Enterprise Messaging Administrator MCITP: Enterprise Messaging Administrator 2010

Hi all, We run Exchange 2007 on Win 2003 R2 machines. I need to make a list of all Exchange users and how big their mailboxes are. I'm not very proficient with the Exchange shell. Any help would be appreciated. Hi, Just to add to Aron's reply: get-mailbox -resultsize unlimited| get-mailboxstatistics |ft DisplayName,@{label="Total Item Size (MB)";expression={$_.TotalItemSize.Value.ToMB() } },ItemCount Instead of ToMB() u can also use ToKB() or ToGB() Regards, Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM) www.HostingController.com

Hi, Just to add to Aron's reply: get-mailbox -resultsize unlimited| get-mailboxstatistics |ft DisplayName,@{label="Total Item Size (MB)";expression={$_.TotalItemSize.Value.ToMB() } },ItemCount Instead of ToMB() u can also use ToKB() or ToGB() Regards, Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM) www.HostingController.com If you choose to do the conversion in powershell I would recommend piping the data to a Select-Object cmdlet so that you can either display it in the host output or export the data. You won't be able to export after a Format-Table. get-mailbox -resultsize unlimited| get-mailboxstatistics | select DisplayName,@{name="Total Item Size (MB)";expression={$_.TotalItemSize.Value.ToMB() } },ItemCount Exchange & Powershell Geek MCITP: Enterprise Messaging Administrator MCITP: Enterprise Messaging Administrator 2010

Yes, Aron you are right thats why i didnt put exporting the output :) Just wanted to convey that some customization can be done for exchange attributes related to size. Regards,Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM) www.HostingController.com

I know I was just pointing out that using select-object is more efficient because you can still pipe that to a Format-Table or to a Export-Csv without having to change the conversion code.Exchange & Powershell Geek MCITP: Enterprise Messaging Administrator MCITP: Enterprise Messaging Administrator 2010

Hi, Yes thanks for pointing that. :) Cheers, Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM) www.HostingController.com

Thanks peeps.