Solved

mailbox database size and mailbox count user

Posted on 2014-04-14
10
4,451 Views
Last Modified: 2014-04-27
Hello Team,

Can anybosy tell the powershell command to check all mailbox database size and mailbox count per database in single command.

Any help will be appreciated

Thanks
0
Comment
Question by:Addy Nadia
[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
  • 5
  • 4
10 Comments
 
LVL 7

Expert Comment

by:Mohammed Tahir
ID: 40001196
0
 
LVL 3

Accepted Solution

by:
Krishna Patil earned 500 total points
ID: 40001210
Hi, Run this command

Get-MailboxDatabase -Status | select Name,@{Label="Free Space";Expression={$_.AvailableNewMailboxSpace.ToMB()}},@{Label="Size";Expression={$_.DatabaseSize.ToMB()}},@{Name="NumberofUsers";Expression={(Get-Mailbox -resultsize unlimited -Database $_.name).Count}} | ft -auto
0
 
LVL 5

Author Comment

by:Addy Nadia
ID: 40009266
Will check nd confirm you
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Author Comment

by:Addy Nadia
ID: 40017058
hello Krishna,

It give me only below result. I still didnt get the how mailbox reside in that databases.
in below Freespace and Size only comes not the number of users..

Name         Free Space Size NumberofUsers
----         ---------- ---- -------------
BCCMBDB00          1354 2312
BCCMBDB10           973 1800
QUUARCDB04          836  904
BCCARCDB10          678  776
BCCARCDB12          122  184
BCCARCDB14          721  776
BCCARCDB16          509  776
BCCARCDB18          762  904
BCCARCDB00          939 1032
BCCARCDB02          817  904
QUUARCDB02          830  904
BCCARCDB04          755  904
BCCARCDB08          770  904
BCCARCDB06          833  904


Please tell how to complete this
0
 
LVL 3

Expert Comment

by:Krishna Patil
ID: 40017127
Its giving me result in following format, Please copy the script, that I shared correctly and no need to paste this in .ps1 file and then execute.


Name                        Free Space Size NumberofUsers
----                        ---------- ---- -------------
Mailbox Database 0461156407         30  247            12
Mailbox Database 0488204167         82  384             2
0
 
LVL 5

Author Comment

by:Addy Nadia
ID: 40019356
It still gives me Same result. Please suggest
0
 
LVL 3

Expert Comment

by:Krishna Patil
ID: 40019483
What is your exchange version? Service pack level?
0
 
LVL 5

Author Comment

by:Addy Nadia
ID: 40019488
Exchange 2010 sp3 with rollup 2
0
 
LVL 3

Expert Comment

by:Krishna Patil
ID: 40019567
For same version, I am getting correct result.

YOu can try following script. I just added specific DB, add just any DB name

Get-MailboxDatabase  -identity DBNAME -Status | select Name,@{Label="Free Space";Expression={$_.AvailableNewMailboxSpace.ToMB()}},@{Label="Size";Expression={$_.DatabaseSize.ToMB()}},@{Name="NumberofUsers";Expression={(Get-Mailbox -resultsize unlimited -Database $_.name).Count}} | ft -auto
0
 
LVL 5

Author Closing Comment

by:Addy Nadia
ID: 40026554
Good
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
In this video we show how to create an email address policy 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 Mail Flow…
This video discusses moving either the default database or any database to a new volume.

726 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