Book Image

PowerShell for Office 365

By : Martin Machado
Book Image

PowerShell for Office 365

By: Martin Machado

Overview of this book

While most common administrative tasks are available via the Office 365 admin center, many IT professionals are unaware of the real power that is available to them below the surface. This book aims to educate readers on how learning PowerShell for Offi ce 365 can simplify repetitive and complex administrative tasks, and enable greater control than is available on the surface. The book starts by teaching readers how to access Offi ce 365 through PowerShell and then explains the PowerShell fundamentals required for automating Offi ce 365 tasks. You will then walk through common administrative cmdlets to manage accounts, licensing, and other scenarios such as automating the importing of multiple users,assigning licenses in Office 365, distribution groups, passwords, and so on. Using practical examples, you will learn to enhance your current functionality by working with Exchange Online, and SharePoint Online using PowerShell. Finally, the book will help you effectively manage complex and repetitive tasks (such as license and account management) and build productive reports. By the end of the book, you will have automated major repetitive tasks in Office 365 using PowerShell.
Table of Contents (16 chapters)
Title Page
About the Authors
About the Reviewer
Customer Feedback

Creating the first user account in PowerShell

If you have an account in Office 365 (even if there is no license assigned to it), using that account you can connect to Office 365 using PowerShell. The operations or cmdlets that you can execute vary depending on the permissions and licenses assigned to that account.


PowerShell cmdlets for Office 365 use the following pattern:


For example, take a look at this:


Here, MSOL = Microsoft Online.

To find out about all the commands, use Get-Command *Msol*.

Once the connection is established successfully, let's create a new user account. To create the user account, the account that we will be using needs to be part of the global administrator role or the user management role.

Ensuring user account permissions

Let's check whether the account has the necessary permissions using the following PowerShell cmdlet:


This cmdlet gets all the administrator roles that the specified user belongs to. It will...