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

Avatar of undefined
Last Comment
Amit Kumar

8/22/2022 - Mon
Amit Kumar

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 Seinfield

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

Display name, Email address, database,
Jerry Seinfield

ASKER
and mailbox size per user
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Amit Kumar

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.