1

I have 25 user with exchange email boxes exchange 2007 in sbs2008 fe

Is there a way to see or show each user and the size of there mailbox to see who is using too much?

Thanks

3 Spice ups
2

I use this for the whole batch

Get-MailboxDatabase "<insert database name or don’t enter one for all DB’s>" | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount (optional | Select –first 25) >> C:\*name_of_file*.txt

Or this

get-mailboxstatistics | fl displayname,totalitemsize

Or this,

Get-Mailbox -Identity "name_of_user" | fl

If you have limits each of those in powershell will show what you want. The first one, outputs to a text file if you want with the top 25 offenders. (make sure to change the optional parameters in that code.)

-Jay

3

Okay Jay something new Powershell…Ive seen this when I type in the search power for power options this pulls up I just close it :slight_smile: but now its time to use it…Okay…

Forgive me the first one will give me all stats with user for thewhole mailbox?

how do i find the database name? is it the mailbox.database.edb?

Thank you for you time and help

4

That will give the first 25 users, their display name, toal size of mailbox in bytes and item count. See the screenshot below for an example I ran from my lab setup. And make sure you are running this from the Exchange management shell, not just regular powershell or it won’t work.

-Jay

mailbox.jpg
mailbox.jpg987×329 123 KB
5

Thats why it didnt work thanks I did run it from regular powershell thanks again

6

Here’s a script I use to get a text report each morning. I wish I’d kept references as to where I got the script from, I sure didn’t come up with this one on my own!

Now this is for Exchange 2010 and unfortunately I’ve changed the E2K7 scripts I used to what’s below, so I don’t remember if there are any incompatibilities. But this should give you some more options in addition to Jay’s suggestions.

Save this as a .ps1 file somewhere, in my case d:\exchange10\scripts\custom on the Exchange server.

###Send mailbox statistics script
###First, the administrator must change the mail message values in this section
$FromAddress = “administrator@unitedwaytriangle.org”
$ToAddress = “mrodgers@unitedwaytriangle.org”
$MessageSubject = “Mailbox Size Report”
$MessageBody = “Attached is the current list of mailbox sizes.”
$SendingServer = “exch01.unitedwaytriangle.org”

###Now get the stats and store in a text file
Get-Mailbox | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=“TotalItemSize(KB)”;expression={$_.TotalItemSize.Value.ToKB()}}, ItemCount,StorageLimitStatus > d:\exchange10\scripts\custom\mailboxes.txt

###Create the mail message and add the statistics text file as an attachment
$SMTPMessage = New-Object System.Net.Mail.MailMessage $FromAddress, $ToAddress,
$MessageSubject, $MessageBody
$Attachment = New-Object Net.Mail.Attachment(“d:\exchange10\scripts\custom\mailboxes.txt”)
$SMTPMessage.Attachments.Add($Attachment)
###Send the message
$SMTPClient = New-Object System.Net.Mail.SMTPClient $SendingServer
$SMTPClient.Send($SMTPMessage)

[These are additional options]
###StorageLimitStatus,LastLogonTime, LastLoggedOnUserAccount,ItemCount, DeletedItemCount

Then create a scheduled task. Use the Start a Program, type Powershell for the program and type in
-psconsolefile d:\exchange10\bin\exshell.psc1 -command d:\exchange10\scripts\custom\sendstats.ps1
in the Add Arguments field.

Have fun!

schedtask.jpg
schedtask.jpg640×640 107 KB
1 Spice up
7

I just added the Microsoft Exchange data box on my Spiceworks main page and it not only shows me the size of the top 5 users but if you click on it, it will show you all of the other users in the exchange server along with the sizes of the mailboxes.

8

Okay Lets Go Blue, I didnt even think about the spiceworks do you by change have instruction on how to install this piece?

Thanks to all for there response keep them coming

9

Here’s a link to a How-To here in the community relating to getting information into Spiceworks. Exchange 2003 information pops-up automatically (as referenced by Let’s Go Blue), Exchange 2007+ information must have a powershell script gather and push the information to Spiceworks. I have been trying to test this script out for a while, but have not yet gotten around to it. I hope it gets you going in the right direction.

http://community.spiceworks.com/how_to/show/1186-how-to-get-exchange-2007-2010-data-into-spiceworks