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
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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Get-DatabaseStatistics is function written in this script, you will have to save full code in a PS1 file named Get-DatabaseStatistics.ps1
It will work for you in Exchange 2013 as well.
It will work for you in Exchange 2013 as well.
Thanks Amit, that worked, but still need the following columns
Display name, Email address, database,
Display name, Email address, database,
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@exchangeserverpr
Please rename attached file in this post as .ps1
Get-MailboxReport.txt
Synopsis from Article for this powershell:
.\Get-MailboxReport.ps1 -All -SendEmail -MailTo alan.reid@exchangeserverpr
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
Premium Content
You need an Expert Office subscription to comment.Start Free Trial