\nThis should work as well<\/p>\n
Get-MailboxStatistics -Database MB01 | Select DisplayName, LastLoggedOnUserAccount, ItemCount, TotalItemSize, LastLogonTime, LastLogoffTime | Export-CSV test.csv<\/p>\n<\/blockquote>\n<\/aside>\n
This is awesome. Then if you want to see the total data you can plug that into a spreadsheet!<\/p>","upvoteCount":0,"datePublished":"2013-05-15T17:35:30.000Z","url":"https://community.spiceworks.com/t/size-of-exchange-email/213017/12","author":{"@type":"Person","name":"benspain","url":"https://community.spiceworks.com/u/benspain"}},{"@type":"Answer","text":"
+1 on SeanMD’s solution, that is essentially what I use as well to determine this info.<\/p>\n
Mike<\/p>","upvoteCount":0,"datePublished":"2013-05-16T01:07:24.000Z","url":"https://community.spiceworks.com/t/size-of-exchange-email/213017/13","author":{"@type":"Person","name":"shelzmike","url":"https://community.spiceworks.com/u/shelzmike"}},{"@type":"Answer","text":"
Okay,<\/p>\n
Guys I tried sean mds and got and error dont ask what it is it all red and to long to interpret the jist of it is I didnt enter something in under Database MB01 should i put something there with my setup if so then what??<\/p>\n
Guy Ive never used this and am learing and do appreciate so much for the help …but need some more detail if can…<\/p>\n
thanks<\/p>","upvoteCount":0,"datePublished":"2013-05-16T02:08:34.000Z","url":"https://community.spiceworks.com/t/size-of-exchange-email/213017/14","author":{"@type":"Person","name":"tannerjones9379","url":"https://community.spiceworks.com/u/tannerjones9379"}},{"@type":"Answer","text":"
Where it reads MB01 change that to your mailbox database and you should be good to go.<\/p>","upvoteCount":0,"datePublished":"2013-05-16T08:49:04.000Z","url":"https://community.spiceworks.com/t/size-of-exchange-email/213017/15","author":{"@type":"Person","name":"seanmdit","url":"https://community.spiceworks.com/u/seanmdit"}}]}}
System SBS Server 2008fe with exchange 2007
How do I find out how big my total email boxes are or how much total mail in exchange?
4 Spice ups
benspain
(BenSpain)
May 15, 2013, 2:17pm
2
http://community.spiceworks.com/scripts/show/383-push-exchange-2010-2007-data-to-spiceworks-and-bypass-powershell-security
This is a Powershell script that runs on your exchange server and pushes your Exchange data into Spiceworks. From there it will display all of that for you!
benspain
(BenSpain)
May 15, 2013, 2:20pm
3
If you need help running it send me a message and I can see what I can do to help you.
Thanks BenJspain,
I don’t have spiceworks on the machined any other way of finding out?
benspain
(BenSpain)
May 15, 2013, 2:29pm
5
Sorry. Here this is the right one. change the name to exchange_push.ps1 and run it from powershell 2.0 on your Exchange Server.
Open Powershell
Change directory to where ever this .ps1 file resides.
Type
./exchange_push.ps1 (SW server DNS name) -p (SW Port)
ie ./exchange_push.ps1 spicyPC -p 8080
exchange_push.ps1.txt (5.46 KB)
1 Spice up
benspain
(BenSpain)
May 15, 2013, 2:36pm
6
make sure you have Powershell 2.0 or higher. If you have never run powershell on that PC before open powershell and type
Set-ExecutionPolicy Unrestricted (case sensitive)
This will allow you to execute powershell cmdlets.
Sorry BenJSpain,
None of this makes sense I don’t have spice works nor do I want to take the time to install it right now just need to know how to find out size of all users mailboxes total?
Thanks
benspain
(BenSpain)
May 15, 2013, 2:57pm
8
Sorry I just assumed I guess… Consider Spiceworks. It’s free and will change your life.
In the meantime does this help?
1. Sorted by Displayname (Display name, Mailbox size (MB), Item count, Last logon time, Last logoff time, Last loggedon user account) Get-MailboxStatistics -Database “mailbox database” …
benspain
(BenSpain)
May 15, 2013, 2:58pm
9
No I suppose that won’t help if you want total
benspain
(BenSpain)
May 15, 2013, 2:59pm
10
seanmdit
(Sean Donnelly)
May 15, 2013, 3:29pm
11
This should work as well
Get-MailboxStatistics -Database MB01 | Select DisplayName, LastLoggedOnUserAccount, ItemCount, TotalItemSize, LastLogonTime, LastLogoffTime | Export-CSV test.csv
3 Spice ups
benspain
(BenSpain)
May 15, 2013, 5:35pm
12
This should work as well
Get-MailboxStatistics -Database MB01 | Select DisplayName, LastLoggedOnUserAccount, ItemCount, TotalItemSize, LastLogonTime, LastLogoffTime | Export-CSV test.csv
This is awesome. Then if you want to see the total data you can plug that into a spreadsheet!
shelzmike
(shelzmike)
May 16, 2013, 1:07am
13
+1 on SeanMD’s solution, that is essentially what I use as well to determine this info.
Mike
Okay,
Guys I tried sean mds and got and error dont ask what it is it all red and to long to interpret the jist of it is I didnt enter something in under Database MB01 should i put something there with my setup if so then what??
Guy Ive never used this and am learing and do appreciate so much for the help …but need some more detail if can…
thanks
seanmdit
(Sean Donnelly)
May 16, 2013, 8:49am
15
Where it reads MB01 change that to your mailbox database and you should be good to go.