Microsoft Exchange Server 2016 PowerShell Cookbook - Fourth Edition

By : Jonas Andersson, Nuno Mota, Mike Pfeiffer

Microsoft Exchange Server 2016 PowerShell Cookbook - Fourth Edition

By: Jonas Andersson, Nuno Mota, Mike Pfeiffer

Overview of this book

We start with a set of recipes on core PowerShell concepts. This will provide you with a foundation for the examples in the book. Next, you'll see how to implement some of the common exchange management shell tasks, so you can effectively write scripts with this latest release. You will then learn to manage Exchange recipients, automate recipient-related tasks in your environment, manage mailboxes, and understand distribution group management within the Exchange Management Shell. Moving on, we'll work through several scenarios where PowerShell scripting can be used to increase your efficiency when managing databases, which are the most critical resources in your Exchange environment. Towards the end, you'll discover how to achieve Exchange High Availability and how to secure your environment, monitor the health of Exchange, and integrate Exchange with Office Online Server, Skype for Business Server, and Exchange Online (Office 365). By the end of the book, you will be able to perform administrative tasks efficiently.

Preface

What this book covers

What you need for this book

Free Chapter

PowerShell Key Concepts

Introduction

Using the help system

Understanding command syntax and parameters

Command aliases

Setting up a PowerShell profile

Understanding the pipeline

Working with variables and objects

Working with arrays and hash tables

Looping through items

Creating custom objects

Using debugger functions

Understanding the new execution policy

Using the Save-Help function

Working with script repositories

Exchange Management Shell Common Tasks

Introduction

Manually configuring remote PowerShell connections

Using explicit credentials with PowerShell cmdlets

Transferring files through remote shell connections

Managing domains or an entire forest using a recipient scope

Exporting reports to text and CSV files

Sending SMTP emails through PowerShell

Scheduling scripts to run at a later time

Logging shell sessions to a transcript

Automating tasks with the scripting agent

Scripting an Exchange server installation

Managing Recipients

Introduction

Creating, modifying, and removing mailboxes

Working with contacts

Managing distribution groups

Managing resource mailboxes

Creating recipients in bulk using a CSV file

Configuring MailTips

Working with recipient filters

Adding and removing recipient email addresses

Hiding recipients from address lists

Configuring recipient moderation

Configuring message delivery restrictions

Managing automatic replies and out-of-office settings for a user

Adding, modifying, and removing server-side inbox rules

Managing mailbox folder permissions

Importing user photos into Active Directory

Managing Mailboxes

Introduction

Reporting on mailbox sizes

Reporting on the mailbox creation time

Working with move requests and performing mailbox moves

Email notification on mailbox moves

Importing and exporting mailboxes

Deleting messages from mailboxes using Search-Mailbox

Deleting messages from mailboxes using Compliance Search

Managing disconnected mailboxes

Setting storage quotas for mailboxes

Finding email addresses with numbers

Finding mailboxes with different SIP and Primary SMTP addresses

Finding inactive mailboxes

Detecting and fixing corrupt mailboxes

Restoring deleted items from mailboxes

Managing public folder mailboxes

Reporting on public folder statistics

Managing user access to public folders

Distribution Groups and Address Lists

Introduction

Reporting on distribution group membership

Adding members to a distribution group from an external file

Previewing dynamic distribution group membership

Backing up distribution groups membership

Excluding hidden recipients from a dynamic distribution group

Converting and upgrading distribution groups

Allowing managers to modify group permissions

Removing disabled users from distribution groups

Working with distribution group naming policies

Working with distribution group membership approval

Creating address lists

Exporting address list membership to a CSV file

Configuring hierarchical address books

Mailbox Database Management

Introduction

Managing the mailbox databases

Moving databases and logs to another location

Configuring the mailbox database limits

Reporting on mailbox database size

Finding the total number of mailboxes in a database

Determining the average mailbox size per database

Reporting on database backup status

Restoring data from a recovery database

Managing Client Access

Introduction

Managing ActiveSync, OWA, POP3, and IMAP4 mailbox settings

Setting internal and external CAS URLs

Managing Outlook Anywhere settings

Blocking Outlook clients from connecting to Exchange

Reporting on active OWA and RPC connections

Controlling ActiveSync device access

Reporting on ActiveSync devices

Managing Transport Servers

Introduction

Configuring transport limits

Managing connectors

Allowing application servers to relay emails

Checking if the IP address is in a receive connector

Comparing receive connectors

Adding IP address to receive connectors

Working with custom DSN messages

Managing connectivity and protocol logs

Searching message tracking logs

Determining which email client sent an email

Working with messages in transport queues

Searching anti-spam agent logs

Implementing a header firewall

Configuring the Edge Transport server role

Exchange Security

Introduction

Granting users full access permissions to mailboxes

Finding users with full access to mailboxes

Sending email messages as another user or group

Throttling client connections

Working with Role Based Access Control

Creating a custom RBAC role for administrators

Creating a custom RBAC role for end users

Troubleshooting RBAC

Generating a certificate request

Installing certificates and enabling services

Importing certificates on multiple Exchange servers

Configuring Domain Security

Configuring S/MIME for OWA

Configuring Windows Defender Exclusions

Compliance and Audit Logging

Introduction

Configuring journaling

Managing archive mailboxes

Configuring archive mailbox quotas

Creating retention tags and policies

Applying retention policies to mailboxes

Placing mailboxes on retention hold

Placing mailboxes on in-place hold or litigation hold

Searching and placing a hold on public folders

Performing eDiscovery searches

Performing Compliance searches

Configuring data loss prevention

Configuring administrator audit logging

Searching the administrator audit logs

Configuring mailbox audit logging

Searching mailbox audit logs

High Availability

Introduction

Creating a Database Availability Group

Adding mailbox servers to a Database Availability Group

Configuring Database Availability Group network settings

Adding mailbox copies to a Database Availability Group

Activating mailbox database copies

Reseeding a database copy

Working with lagged database copies

Using the automatic reseed feature

Performing maintenance on Database Availability Group members

Reporting on database status, redundancy, and replication

Monitoring Exchange Health

Introduction

Using Exchange test cmdlets

Using Health Probe checks

Checking the server health and health sets

Monitoring transaction logs

Monitoring the disk space

Checking database redundancy

Integration

Introduction

OAuth configuration

Configuring Exchange archiving for Skype for Business Server

Configuring and enabling the Unified Contact Store

Integrating Skype for Business with Outlook on the web

Configuring a user with a high-resolution photo

Office Online Server integration

Validating Exchange hybrid

Scripting with the Exchange Web Services Managed API

Introduction

Getting connected to EWS

Sending email messages with EWS

Working with impersonation

Searching mailboxes

Retrieving the headers of an email message

Deleting email items from a mailbox

Creating calendar items

Exporting attachments from a mailbox

Common Shell Information

Exchange Management Shell reference

Properties that can be used with the -Filter parameter

Properties that can be used with the -RecipientFilter parameter

Query Syntaxes

Using the word phrase search

Using a date range search

Using the message type search

Using search operators

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Determining the average mailbox size per database

PowerShell is very flexible and gives you the ability to generate very detailed reports. When generating mailbox database statistics, we can utilize data returned from multiple cmdlets provided by the Exchange Management Shell. This recipe will show you an example of this, and you will learn how to calculate the average mailbox size per database using PowerShell.

How to do it...

To determine the average mailbox size for a given database, use the following one-liner:

    Get-MailboxStatistics -Database DB1 | 
      ForEach-Object {$_.TotalItemSize.Value.ToMB()} | 
        Measure-Object -Average | 
          Select-Object -ExpandProperty Average

...

Microsoft Exchange Server 2016 PowerShell Cookbook - Fourth Edition

By : Jonas Andersson, Nuno Mota, Mike Pfeiffer

Microsoft Exchange Server 2016 PowerShell Cookbook - Fourth Edition

By: Jonas Andersson, Nuno Mota, Mike Pfeiffer

Overview of this book

Related Content you might be interested in

Current Title:

Microsoft Exchange Server 2016 PowerShell Cookbook - Fourth Edition

Practical PowerShell Exchange Server 2016

Practical PowerShell Exchange Server 2019

Practical PowerShell Office 365: Exchange Online