Solved

How to Show Mailboxes, Their Sizes, in Each Database

Posted on 2010-11-23
5
5,371 Views
Last Modified: 2012-05-10
Good morning experts,
I have an AD domain (2008 R2) with an Exchange 2010 mail server. I am looking for a Powershell script that will show all of the databases, and list the mailboxes and sizes within each database. The output I desire is csv, although print to the screen is ok also.
0
Comment
Question by:CraigMan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 7

Expert Comment

by:Exchange_Freak
ID: 34199530
Try this

Get-DatabaseStatistics | Export-Csv c:\windows\temp\report.csv -Force -NoType

0
 
LVL 17

Expert Comment

by:Viral Rathod
ID: 34199561
0
 
LVL 17

Expert Comment

by:Viral Rathod
ID: 34199596
Try following power shell command to get the mailboxsize,total item, email address etc....

Get-Mailbox -server EXCH14-MBX1 | Select-Object name,primarysmtpaddress, DisplayName,Database,@{n="Size(MB)";e =
   {$MBXstat = Get-MailboxStatistics $_.name; $MBXstat.totalItemsize.value.toMB()}},@{n="Items"; e = {$MBXstat = Get-
    MailboxStatistics $_.name ; $MBXstat.itemcount}}
0
 
LVL 17

Accepted Solution

by:
Viral Rathod earned 500 total points
ID: 34199621
0
 

Author Closing Comment

by:CraigMan
ID: 34201410
Thanks
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

689 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question