Link to home
Start Free TrialLog in
Avatar of Jerry Seinfield
Jerry SeinfieldFlag for United States of America

asked on

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
Avatar of Amit Kumar
Amit Kumar
Flag of India image

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.
Avatar of Jerry Seinfield

ASKER

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

Display name, Email address, database,
and mailbox size per user
ASKER CERTIFIED SOLUTION
Avatar of Amit Kumar
Amit Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial