Checking your Exchange database size in PowerShell is key in several scripting scenarios, such as creating mailboxes in the smallest database, or generating basic database reports. The problem in Exchange 2007 was that this was a lot harder than it sounded. The Get-MailboxDatabase cmdlet did not return the size of the database. If you needed to determine the database size, you had to write some fairly lengthy code to get what you think would be be easily accessible information.
Exchange 2007
There are a couple methods you can use to get this information in Exchange 2007. Here is a great example posted by Gary Siepser; it's a one-liner that retrieves the database size using WMI, allowing you to run it against clustered mailbox servers:
Exchange 2010
Fortunately, the Get-MailboxDatabase cmdlet in Exchange 2010 provides this information for us out of the box. All you need to do is use the Status parameter and you can access the information using the DatabaseSize property. Here is an example:
I actually used this technique in another post, but didn't explain it in depth. I recently noticed someone still doing it "the hard way" and I realized this may make for a good quick tip – hope it helps.
{ 2 trackbacks }
{ 4 comments… read them below or add one }
Hi Mike,
Thanks its useful for me, but is there any way to get the usage report of each database with powershell ?
or any other easy way to get the usage report of databases…
Thanks
Sure, what other details are you looking for? Have you seen this? http://www.mikepfeiffer.net/2010/03/exchange-2010-database-statistics-with-powershell/
Thank you, very helpfull !
Perfect. Thanks!