Book Image

Microsoft Exchange Server 2013 PowerShell Cookbook: Second Edition - Second Edition

Book Image

Microsoft Exchange Server 2013 PowerShell Cookbook: Second Edition - Second Edition

Overview of this book

Microsoft Exchange Server 2013 is a complex messaging system. Windows PowerShell 3 can be used in conjunction with Exchange Server 2013 to automate and manage routine and complex tasks to save time, money, and eliminate errors.Microsoft Exchange Server 2013 PowerShell Cookbook: Second Edition offers more than 120 recipes and solutions to everyday problems and tasks encountered in the management and administration of Exchange Server. If you want to write scripts that help you create mailboxes, monitor server resources, and generate detailed reports, then this Cookbook is for you. This practical guide to Powershell and Exchange Server 2013 will help you automate and manage time-consuming and reoccurring tasks quickly and efficiently. Starting by going through key PowerShell concepts and the Exchange Management Shell, this book will get you automating tasks that used to take hours in no time.With practical recipes on the management of recipients and mailboxes as well as distribution groups and address lists, this book will save you countless hours on repetitive tasks. Diving deeper, you will then manage your mailbox database, client access, and your transport servers with simple but effective scripts.This book finishes with advanced recipes on Exchange Server problems such as server monitoring as well as maintaining high availability and security. If you want to control every aspect of Exchange Server 2013 and learn how to save time with PowerShell, then this cookbook is for you.

Related Content you might be interested in

Current Title:

Small book image
Microsoft Exchange Server 2013 PowerShell Cookbook: Second Edition - Second Edition
May, 2013 | 504 pages
No titles found
Table of Contents (23 chapters)
Microsoft Exchange Server 2013 PowerShell Cookbook
Microsoft Exchange Server 2013 PowerShell Cookbook
Credits
Credits
About the Authors
About the Authors
Acknowledgement
Acknowledgement
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
PowerShell Key Concepts
PowerShell Key Concepts
Introduction
Using the help system
Understanding command syntax and parameters
Understanding the pipeline
Working with variables and objects
Formatting output
Working with arrays and hash tables
Looping through items
Creating and running scripts
Using flow control statements
Creating custom objects
Creating PowerShell functions
Setting up a profile
2
Exchange Management Shell Common Tasks
Exchange Management Shell Common Tasks
Introduction
Manually configuring remote PowerShell connections
Using explicit credentials with PowerShell cmdlets
Transferring files through remote shell connections
Dealing with concurrent pipelines in remote PowerShell
Managing domains or an entire forest using recipient scope
Exporting reports to text and CSV files
Sending SMTP e-mails 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
3
Managing Recipients
Managing Recipients
Introduction
Adding, modifying, and removing mailboxes
Working with contacts
Managing distribution groups
Managing resource mailboxes
Creating recipients in bulk using a CSV file
Working with recipient filters
Adding and removing recipient e-mail 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
4
Managing Mailboxes
Managing Mailboxes
Introduction
Reporting on the mailbox size
Working with move requests and performing mailbox moves
Mailbox move e-mail notification
Importing and exporting mailboxes
Deleting messages from mailboxes
Managing disconnected mailboxes
Generating mailbox folder reports
Reporting on mailbox creation time
Checking mailbox logon statistics
Setting storage quotas for mailboxes
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
5
Distribution Groups and Address Lists
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
Excluding hidden recipients from a dynamic distribution group
Converting and upgrading distribution groups
Allowing managers to modify group membership
Removing disabled user accounts 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
6
Mailbox Database Management
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
7
Managing Client Access
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
8
Managing Transport Service
Managing Transport Service
Introduction
Managing connectors
Configuring transport limits
Allowing application servers to relay mail
Managing transport rules and settings
Creating a basic disclaimer
Working with custom DSN messages
Managing connectivity and protocol logs
Searching message tracking logs
Working with messages in transport queues
Searching anti-spam agent logs
Implementing a header firewall
9
High Availability
High Availability
Introduction
Building a Windows NLB cluster for CAS servers
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
Working with lagged database copies
Reseeding a database copy
Using the automatic reseed feature
Performing maintenance on Database Availability Group members
Reporting on database status, redundancy, and replication
10
Exchange Security
Exchange Security
Introduction
Granting users full access permissions to mailboxes
Finding users with full access to mailboxes
Sending e-mail messages as another user or group
Working with Role Based Access Control (RBAC)
Creating a custom RBAC role for administrators
Creating a custom RBAC role for end users
Troubleshooting Role Based Access Control
Generating a certificate request
Installing certificates and enabling services
Importing certificates on multiple exchange servers
11
Compliance and Audit Logging
Compliance and Audit Logging
Introduction
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
Performing a discovery search
Enabling mailbox audit logging
Generating mailbox audit log reports
Configuring Administrator Audit Logging
Searching the administrator audit logs
12
Server Monitoring and Troubleshooting
Server Monitoring and Troubleshooting
Introduction
Managing and monitoring services
Verifying server connectivity
Working with event logs
Reporting on disk usage
Checking CPU utilization
Monitoring memory utilization
Reporting on Exchange Server uptime
Troubleshooting the Mailbox role
Troubleshooting the Client Access Server role
Troubleshooting the Transport service
Verifying certificate health
13
Scripting with the Exchange Web Services Managed API
Scripting with the Exchange Web Services Managed API
Introduction
Getting connected to EWS
Sending e-mail messages with EWS
Working with impersonation
Searching mailboxes
Retrieving the headers of an e-mail message
Deleting e-mail items from a mailbox
Creating calendar items
Exporting attachments from a mailbox
Common Shell Information
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
Query Syntaxes
Advanced Query Syntax
Using the word phrase search
Using a date range search
Using the message type search
Using the logical connector search
Index
Index

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

How it works...

Calculating an average is as simple as performing some basic math, but PowerShell gives us the ability to do this quickly with the Measure-Object cmdlet. The example uses the Get-MailboxStatistics cmdlet to retrieve all the mailboxes in the DB1 database. We then loop through each one, retrieving only the...

Previous Section
End of Section 8
Next Section