Generating Exchange Environment Report

Generating Exchange Environment Report

This script automatically generate a report that give an overview of our existing environment with following contents.

Total Servers per Exchange version & service pack
Total Mailboxes per Exchange version & service pack, plus Office 365 remote mailboxes
Totals for Exchange roles across the environment

• A site-by-site breakdown for the following:

1. Mailboxes per site
2. HTTPS FQDNs used for Internal, External and SCP URLs
3. CAS array names
4. Exchange servers, version, update rollup and version, service level, highlighted installed roles, OS version and service pack

• A breakdown of each Database Availability Group including:

1. DAG name, member count and member list
2. Database information such as
3. Name
4. Mailboxes per database and Average Size
5. Archive mailboxes (If Available) per database and Average Size – only shown if a DB includes Archive mailboxes
6. Database and whitespace size
7. Database and log disk free space percentage
8. Last full backup date/time (new) – only shown if at least one DAG DB has had a full backup
9. Circular Logging state (new) – only shown if at least one DAG DB has circular logging enabled (If Available)
10. Server hosting the active copy
11. List of servers hosting copies and copy count.

A breakdown of Non-DAG databases including Exchange 2007 DBs, including the database information above, along with Storage Group name.

This dashboard is limited to Exchange 2003/2007 and Public folders. Where it does not give detailed information’s for Exchange 2007 clusters. But, shows the output as ClusMBX in the output.

Script to Generate the Exchange Environment Report

Download the Script from the following link.

Save this script in Text format and convert into ps1. or Directly save in PS1 format.

https://drive.google.com/open?id=0B9raLabzxFwxRlhKVjFkY2JsRzA

Executing the script is straightforward – the only setting you need is to specify where to write the HTML file:

.\Get-ExchangeEnvironmentReport -HTMLReport c:\report.html

If you want it to email the results, the follow parameters are available to allow the report to be sent directly from the script:

.\Get-ExchangeEnvironmentReport -HTMLReport c:\report.html -SendMail:$true -MailFrom:you@example.com -MailTo:you@example.com -MailServer:smtp.example.com

Finally, to schedule the report to be generated nightly, execute with your preferred options and add the -ScheduleAs parameter, for example:

.\Get-ExchangeEnvironmentReport -HTMLReport c:\report.html -SendMail:$true -MailFrom:you@example.com -MailTo:you@example.com -MailServer:smtp.example.com -ScheduleAs:DOMAIN\user

Output View of this Report.

Thank you for visiting my blog

Please update your comments or feedback.

Contact me @: exctech2013@gmail.com