Just can't get enough of IT

Description

When you want to migrate your modern public folders from Exchange 2013 or newer to modern public folders in Exchange Online, you must prepare the public folder names for migration.

Public folder names are not allowed to contain the following:

• A backslash "\"
• A forward slash "/"
• A semicolon ";"
• A comma ","
• A colon ":"
• Leading or trailing spaces

The script Fix-ModernPublicFolderNames.ps1 fixes the public folder names to prepare migration to modern public folders in Exchange Online.

Examples

# EXAMPLE 1
# Rename and trim public folders

.\Fix-ModernPublicFolderNames.ps1

# EXAMPLE 2
# Rename and trim public folders, export list of renamed 
# folders and folders with renaming errors as text files

.\Fix-ModernPublicFolderNames.ps1 -ExportFolderNames

Version History

• 1.0, Initial community release

Links

• Download and follow at Github: https://github.com/Apoc70/Fix-PublicFolderNames

Follow

• Twitter @stensitzki
• LinkedIn

Community

Are you located in Germany, Austria, or Switzerland? Join the Exchange User Group DACH to collaborate with other Exchange enthusiasts.
Follow us on Twitter @exusg, join on Meetup, or visit our website. 

Exchange Server uses Receive Connectors for providing SMTP endpoints for incoming connections. A modern Exchange Server provides a default connector on TCP port 25. 

Sometimes you might have a requirement to create a new receive connector for selected incoming SMTP connections. A standard requirement is a receive connector for relaying messages to external recipients. This cannot (should not) be achieved using the default connector.

Each connector uses the RemoteIPRanges attribute to store the list of IP addresses of remote systems that can connect to that connector. The default connector utilizes the full IPv4 and IPv6 addresses ranges.

Your new receive connector requires at least a single IP address for a selected remote system that is supposed to connect to that receive connector. You can add a single IP address, address ranges, or IP addresses using CIDR notation.

The attribute RemoteIPRanges is a multi-value attribute and has a limit of IP address entries that can be added. 

The maximum number of address entries that you can add to that attribute varies. You can store approximately 1,300 entries.

When you exceed the number of values you receive the following error message:

The administrative limit for this request was exceeded.
    + CategoryInfo          : NotSpecified: (:) [Set-ReceiveConnector], AdminLimitExceededException
    + FullyQualifiedErrorId : [Server=EX01,RequestId=ee9d45ad-418b-4172-9235-963eca1a7830,TimeStamp=18.08.2020
    20:07:54] [FailureCategory=Cmdlet-AdminLimitExceededException] AC1E336E,Microsoft.Exchange.Management.SystemConfi
  gurationTasks.SetReceiveConnector
    + PSComputerName        : ex01.varunagroup.de

I have tested the number of values that can be stored in that multi-value attribute. Depending on the IP address format I was able to add 1,238 (172.80.x.y) or 1,244 (10.1.x.y) single IP addresses to the RemoteIPRanges attribute.

Plan your IP address configuration requirements carefully and avoid using single IP addresses. Preferably, you should use IP address ranges or IP address CIDR notation for networks.

Links

• Set-ReceiveConnector

Enjoy Exchange Server!

Are you located in Germany, Austria, or Switzerland? Join the Exchange User Group DACH to collaborate with other Exchange enthusiasts.
Follow us on Twitter @exusg, join on Meetup, or visit our website. 

Description

This script reads Exchange Organization data and creates a single Microsoft Word document. A later version will support exporting to an Html file.

The script requires an Exchange Management Shell for Exchange Server 2016 or newer. Older EMS versions are not tested.

A locally installed version of Word is required, as plain Html export is not available, yet.

The default file name is 'Exchange-Org-Report [TIMESTAMP].docx'. 

Most of the script requires only Exchange admin read-only access for the Exchange organization. Querying address list information requires a membership in the RBAC role "Address Lists".

The script queries hardware information from the Exchange server systems and requires local administrator access to the computer systems.

Examples

# Example 1
# Create a Word report for the local Exchange Organization using 
# the default values defined on the parameters section of the PowerShell script.

.\Get-ExchangeOrganizationReport.ps1 -ViewEntireForest:$true

# Example 2
# Create a Microsoft Word report for the local Exchange Organization with 
# a verbose output to the current PowerShell session.

.\Get-ExchangeOrganizationReport.ps1 -Verbose

Version History

• 0.9. Initial community release
• 0.91, Information about processor cores, memory, and page file size added

Links

• Download and follow at Github: https://github.com/Apoc70/Get-ExchangeOrganizationReport
• Download and like at TechNet Gallery: https://gallery.technet.microsoft.com/Gather-Exchange-Organizatio-8c0dd625

Additional Credits

The script is based on the ADDS_Inventory.ps1 PowerScript by Carl Webster: https://github.com/CarlWebster/ActiveDirectory

Follow

• Twitter @stensitzki
• LinkedIn
• Xing

Description

This script gathers a list of enabled users for a selected Exchange Server client protocol. The list of users is sent by email as HTML text in the email body or as an attached CSV file. You can select to gather data for a single protocol or for all protocols.

Available protocols are:

• POP
• IMAP
• ActiveSync

Requirements

• Windows Server 2012 R2 or newer
• Exchange 2016+ Management Shell
• GlobalFunctions module (found here)

Examples

# Find users having all protocols enabled, create a CSV file per protocol and send an email with CSV attachments

.\Get-EnabledProtocolReport.ps1 -SendMail -MailFrom automation@varunagroup.de -MailTo report@varunagroup.de -MailServer relay.varunagroup.de -Protocol ALL


# Find users having all protocols enabled, create a CSV file per protocol

.\Get-EnabledProtocolReport.ps1 -Protocol ALL -ExportCsv

Version History

• 1.0, Initial community release

Links

• Download and follow at Github: https://github.com/Apoc70/Get-EnabledProtocolReport
• Download and like at TechNet Gallery: https://gallery.technet.microsoft.com/Script-to-remove-unwanted-9d119c6b

Follow Me

• Twitter @stensitzki
• LinkedIn
• Xing

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

Links

• Download and follow at Github: https://github.com/Apoc70/Get-ExchangeEnvironmentReport
• Download and like at TechNet Gallery: https://gallery.technet.microsoft.com/Exchange-Environment-11fa7246

Additional Credits

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

Follow

• Twitter @stensitzki
• LinkedIn
• Xing