how in gods name do i view the size of my users mailbox in exchange 2007.it was so easy in exchange 2003.. im guessing i need to use the command shell in 2007 since i cant seem to find it anywhere in the EMCall i have found so far is get-MailBoxStasticticsbut this only shows me the number of items in a mailbox, i want to know the size...please help!

for a single mailbox you can use 'Get-MailboxStatistics | fl' for multiple mailboxes use 'Get-MailboxStatistics | ft Displayname, TotalItemSize'

hi rakem how do i view mailbox size wx2003 for all user? thanks in advance

Hi, if you mean in Exchange Server 2003, then by default when you go to mailbox folder or container under Exchange System Management Console, there is a column for mailbox size , the size will be in KB. this will show you the size of the user mailboxes under this mailbox store. but if you have multiple stores, then you need to to query using active directory from the exchange server itself, and customize the columns and add i think "mailbox size" , or something like that. this will gives you the size of all your user's mailboxes under all mailbox stores. is this what you mean ? Regards Alaa

Hang on a second....this is the ANSWER? I mean yeah it works, but isn't it important to hand your management a report of value? In Bytes...WTF. Has anyone found a valuable way to report? No disrespect to Lasse...I know your just working with what ya got as well. I mean, yeah it works.

You can convert the output from bytes to KB or MB if you like, and sort the result aswell. Get-MailboxStatistics | Sort -Property TotalItemsize -Desc | Format-Table DisplayName, @{expression={$_.TotalItemSize.Value.ToMB()};width=8;label="Mailbox size(MB)"}, ItemCount, LastLogonTime, LastLogoffTime, LastLoggedonUserAccount

How can you output this data to a file? Thanks.

with a "> filename.txt" at the end Get-MailboxStatistics | Sort -Property TotalItemsize -Desc | Format-Table DisplayName, @{expression={$_.TotalItemSize.Value.ToMB()};width=8;label="Mailbox size(MB)"}, ItemCount, LastLogonTime, LastLogoffTime, LastLoggedonUserAccount > mailboxsize.txt

Does anyone know if I can a list of Display Names and the size of each users deleted items folder only?

Try get-mailboxfolderstatistics http://technet.microsoft.com/en-us/library/aa996762.aspx

Hi, this command is very useful! By the way, how can i make the displayname and lastloggedonuseraccount to completely display the content instead of partly? thanks in advance!

can i make this as schedule task to run every month?

Save the powershell commands as a .ps1 file (powershell script) and set that in scheduled tasks. As far as the display of the output the format-table command should give you all the control you need. I find this link to be helpful everyday for this sort of stuff: http://technet.microsoft.com/en-us/library/bb123703.aspx

Add the parameter -autosize to format-table Get-MailboxStatistics | Sort -Property TotalItemsize -Desc | Format-Table DisplayName, @{expression={$_.TotalItemSize.Value.ToMB()};width=8;label="Mailbox size(MB)"}, ItemCount, LastLogonTime, LastLogoffTime, LastLoggedonUserAccount -autosize

Very useful tool, thank you. How can I run this as a batch file in the Power Shell?

create teh powershell script file and then schedule it ot run with a schedule task. http://weblogs.asp.net/steveschofield/archive/2008/01/09/send-email-with-powershell-script-schedule-script-with-windows-task-scheduler.aspx make the script output to a textfile, you can even add the textfileto a mail that gets send in the end of the script.

Use the below cmd in powershell Get-MailboxStatistics -Server MailboxServer01 where Mailboxserver01 is your exchange server name

Got it. Works like a champ. Thanks.