Exchange 2013 database statistics

Hello  team,

I was asked to write a script that would email a daily report of Exchange 2013 database statistics. The customer wanted the following information about each database:
•Total database size
•Total number of mailboxes per database
•Average mailbox size
•Date and time of the last full backup
•Amount of white space in the database

Checking online, I came across with the following links

https://technet.microsoft.com/en-us/library/dd876852(v=exchg.150).aspx


and this one for Exchange 2010

http://mikepfeiffer.net/2010/03/exchange-2010-database-statistics-with-PowerShell/

Since the get-databasestatistics has been deprecated in Exchange 2013 and replace with Get-StoreUsageStatistics, how can I build the script to get all the information above?


Your feedback is highly appreciated
Jerry SeinfieldAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Amit KumarCommented:
Get-DatabaseStatistics is function written in this script, you will have to save full code in a PS1 file named Get-DatabaseStatistics.ps1. Then you will be able to run this powershell with Get-DatabaseStatistics.ps1

It will work for you in Exchange 2013 as well.
0
Jerry SeinfieldAuthor Commented:
Thanks Amit, that worked, but still need the following columns

Display name, Email address, database,
0
Jerry SeinfieldAuthor Commented:
and mailbox size per user
0
Amit KumarCommented:
Please follow this article, it has attached a script even I have attached in this post as well.

Synopsis from Article for this powershell:

.\Get-MailboxReport.ps1 -All -SendEmail -MailTo alan.reid@exchangeserverpro.net  -MailFrom exchangereports@exchangeserverpro.net -MailServer smtp.exchangeserverpro.net

Extracting useful reports about Exchange Server mailbox sizes and other statistics is easy with PowerShell. However it can be quite tedious to construct the right command line to get the information you want.

This PowerShell script, Get-MailboxReport.ps1, takes the heavy lifting out of this process by providing you with an easy to run script to generate a CSV report of mailboxes on a server, database, or in an entire Exchange Server organization.

Please rename attached file in this post as .ps1
Get-MailboxReport.txt
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.