Comments on: Browsing Mailbox Databases in Exchange 2007 and 2010 https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/ Practical Office 365 News, Tips, and Tutorials Wed, 28 Jul 2021 02:45:44 +0000 hourly 1 https://wordpress.org/?v=6.6.1 By: new2IT https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/#comment-236081 Wed, 28 Jul 2021 02:45:44 +0000 https://www.practical365.com/?p=1169#comment-236081 Proxy-SI cringe

]]>
By: Ferdie https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/#comment-190152 Mon, 11 Feb 2019 08:44:47 +0000 https://www.practical365.com/?p=1169#comment-190152 In reply to Scott K Swan.

FT or Format-Table doesnt work well with Export-CSV.

Use SELECT-OBJECT instead of FT.

Get-MailboxStatistics -Database “DatabaseName” | Sort -Property TotalItemsize -desc| Select-Object DisplayName, LastLoggedOnUserAccount, ItemCount, @{expression={$_.totalitemsize.value.ToMB()};label=”Size(MB)”}, LastLogonTime, LastLogoffTime | Export-CSV test.csv

]]>
By: Richard Darling https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/#comment-159694 Thu, 21 Jun 2018 15:03:30 +0000 https://www.practical365.com/?p=1169#comment-159694 Works eveytime, and gives user and mailbox size:

Get-MailboxStatistics -Server ‘SW-EXCH’ | where {$_.ObjectClass -eq “Mailbox”} | Sort-Object TotalItemSize -Descending | ft @{label=”User”;expression={$_.DisplayName}},@{label=”Total Size (MB)”;expression={$_.TotalItemSize.Value.ToMB()}} -auto >> “c:\mailbox_size.txt”

]]>
By: Rob Pelletier https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/#comment-157597 Wed, 07 Mar 2018 15:37:34 +0000 https://www.practical365.com/?p=1169#comment-157597 Couldn’t get the command to work – “Pipelines cannot be executed concurrently”.
The one offered by “Proxy-Si” worked, but there were a bunch of columns that I didn’t need, so I had to go thru the CSV file and clean up. Not sure where the time-saving everybody raves about kicks in…

I don’t hate Powershell, but I am annoyed that there doesn’t seem to be a consistent and complete source of information on it. A list of commands is available anywhere (including in Powershell itself), but a complete listing of the various switches, options, and output syntax is not available anywhere that I’ve been able to find. It’s a long painstaking process trying to figure out how to make it do what you want.

If I worked in a large company with enough staff to allow us the luxury of having someone sit around half the time figuring all this stuff out, I’d use it more. As it is, if it weren’t for sites like this one, with folks able to take the time to learn this very complicated and poorly documented scripting language (and willing to share), I’d likely never use it.

Life’s too short.

Thanks to Paul (and his readers), I can find it and use it. But I likely will never learn it…

]]>
By: Frankly Benson https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/#comment-32021 Fri, 27 Jan 2017 04:50:49 +0000 https://www.practical365.com/?p=1169#comment-32021 Didn’t work. Not sure if Microsoft changed something or if it is one of those (many) PowerShell is screwed up things. But my output for the Get-MailboxStatistics only shows item count. It does not show database size as your example output. The only way I see to get the actual size is Get-MailboxStatistics -identity ” | fl.

Boooo for PowerShell. Sorry, just how I feel.

]]>
By: Frankly Benson https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/#comment-31989 Fri, 27 Jan 2017 04:15:20 +0000 https://www.practical365.com/?p=1169#comment-31989 In reply to Wayne.

I’m one of those 80’s folks, so have always been very comfortable with scripting. I also have to disagree on Powershell being an advance. It is lousy! Syntax is not consistent. Commands are more likely to be “not recognized” than to actually work, because of the way modules are loaded in and out. Generating simple information requires piping so many different commands together it is ridiculous.

Nice try by Microsoft, but they need to scrap it and start again. Take a hint old scripting languages to get it right. And while they are at it, why not keep the GUI full-functional and also provide solid scripting capability?

]]>
By: sanju https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/#comment-4335 Tue, 19 Jan 2016 05:59:39 +0000 https://www.practical365.com/?p=1169#comment-4335 Amazing.. helped me a lot

]]>
By: TTom https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/#comment-4334 Wed, 11 Nov 2015 14:27:48 +0000 https://www.practical365.com/?p=1169#comment-4334 Thanks for your support!
Finally, how to add to the database list the size of databases?

]]>
By: Sérgio Tivane https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/#comment-4333 Tue, 07 Jul 2015 11:14:18 +0000 https://www.practical365.com/?p=1169#comment-4333 Hi Paul,

Thanks very much for your priceless support, you´re a star!

Your articles never let me down.

Keep it up sharing your valuable knowledge.

Cheers

]]>
By: Proxy-SI- https://practical365.com/browsing-mailbox-databases-in-exchange-2007-and-2010/#comment-4332 Tue, 24 Mar 2015 19:26:47 +0000 https://www.practical365.com/?p=1169#comment-4332 To those “NEW” IT Admin’s/Technicians out there who complain about Powershell and having to take on a new learning curve please shut up and stop complaining.

After 10 years i can honestly say i have not stopped taking on new challenges, learning new technologies, new tools that make my life easier. Before Powershell and EXCHANGE i was using Oracle Solaris and a simple mail server which has pop, imap and smtp. Everything was done via a CLI. I still prefer this as it has more functionality, more options than these GUI products contain.

Serious the new generation of IT are like script kiddies out there whom need someone to code the program in a way they can do everything in 1 or 2 clicks of the mouse. Embarassing.

This script works very well actually;
I have found that:

Get-MailboxDatabase | Get-MailboxStatistics | Sort totalitemsize -desc | Export-CSV C:mailboxes.csv

Works Quite Well for those whom need to create some report for their higher up or senior in regards to mailbox size management. It works in Exchange 2010 SP1, 2, and 3. Works in Server 2012 R2 as well as previous 2012 and 2008 R2. If you can’t get this command to work your exchange server has more problems than you can imagine and maybe you should be looking in eventvwr or any other tools you have for monitoring and managing the server.

Just wanted to write this up because every time i enter a forum where someone posts a working script there are a bunch of amateur IT folks who try to claim it doesn’t work for them. It isn’t the script, its the person who doesn’t know what they are doing but decide to do it anyways not knowing the consequences, these are the SAME IT Folks who reduce the number of permanent position jobs out there because they *FUCK* up the previous job so the employer does contract work only thereafter.

Thank you,

Proxy-Si-
(IRC User – Botnet 50K Class approaching 75K – Well known IT Administrator in Toronto)

]]>