Exchange Environment Report – V2

Description

This script creates an HTML report showing the following information about an Exchange 2019, 2016, 2013, 2010, and, to a lesser extent, 2007 and 2003 environment.

The report shows the following:

•  As summary
  • Total number of servers per Exchange Server version
  • Total number of mailboxes per On-Premises Exchange Server version, Office 365, and Exchange Organisation
  • Total number of Exchange Server functional roles
     
• Per Active Directory Site
  • Total number of mailboxes
  • Internal, External, and CAS Array names
  • Exchange Server computers
    • Product version
    • Service Pack, Update Rollup, and/or Cumulative Update
    • Number of preferred and maximum active databases
    • Functional Roles
    • Operating System with Service Pack
       
• Per Database Availability Group
  • Total number of member servers
  • List of member servers
  • DAG databases
    • Number of mailboxes and average mailbox size
    • Number of archive mailboxes and average archive mailbox size
    • Database size
    • Database whitespace
    • Disk space available for database and log file volume
    • Last full backup timestamp
    • Circular logging enabled
    • Mailbox server hosting an active copy
    • List of mailbox servers hosting database copies
       
• Per Database (Non-DAG, pre-DAG Exchange Server)
  • Storage group and database name
  • Server name hosting the database
  • Number of mailboxes and average mailbox size
  • Number of archive mailboxes and average archive mailbox size
  • Database size
  • Database whitespace
  • Disk space available for database and log file volume
  • Last full backup timestamp
  • Circular logging enabled
     

The script uses a separate CSS file for styling the HTML output.

Examples

# Example 1
# Generate an HTML report and send the result as HTML email with attachment 
# to the specified recipient using a dedicated smart host
.\Get-ExchangeEnvironmentReport.ps1 -HTMReport ExchangeEnvironment.html -SendMail 
-ViewEntireForet $true -MailFrom roaster@mcsmemail.de `
-MailTo grillmaster@mcsmemail.de -MailServer relay.mcsmemail.de

Example Screenshot

Version History

• 2.0, Initial community release
• 2.1, Table header label updated for a more consistent labeling
• 2.2, Bug fixes and enhancements
  • CCS fixes for Html header tags (issue #5)
  • New script parameter ShowDriveNames added to optionally show drive names for EDB/LOG file paths in database table (issue #4)
  • Exchange organization name added to report header
• 2.4, Bugfix for empty ExternalUrl parameter values

Links

• Download and follow at Github: https://github.com/Apoc70/Get-ExchangeEnvironmentReport

Additional Credits

Additional credits go to Steve Goodman for the original Exchange Environment Report V1.x scripts.

Follow

• Twitter @stensitzki
• LinkedIn