Exchange 2013 database statistics

Jerry Seinfield
Jerry Seinfield used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015

Commented:
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.

Author

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

Display name, Email address, database,

Author

Commented:
and mailbox size per user
Top Expert 2015
Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial