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: 2015-06-25

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get this solution by purchasing an Individual license! Start your 7-day free trial.

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.

LVL 19

Amit KumarCommented: 2015-06-25

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.

Jerry SeinfieldAuthor Commented: 2015-06-26

Thanks Amit, that worked, but still need the following columns

Display name, Email address, database,

Jerry SeinfieldAuthor Commented: 2015-06-26

and mailbox size per user

LVL 19

Amit KumarCommented: 2015-06-26

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

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