Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5289
  • Last Modified:

mailbox database size and mailbox count user

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
Addy Nadia
Asked:
Addy Nadia
  • 5
  • 4
1 Solution
 
Mohammed TahirCommented:
0
 
Krishna PatilCommented:
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
 
Addy NadiaExpertAuthor Commented:
Will check nd confirm you
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
Addy NadiaExpertAuthor Commented:
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
 
Krishna PatilCommented:
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
 
Addy NadiaExpertAuthor Commented:
It still gives me Same result. Please suggest
0
 
Krishna PatilCommented:
What is your exchange version? Service pack level?
0
 
Addy NadiaExpertAuthor Commented:
Exchange 2010 sp3 with rollup 2
0
 
Krishna PatilCommented:
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
 
Addy NadiaExpertAuthor Commented:
Good
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now