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.

Related Content you might be interested in

Current Title:

Small book image
PowerShell for Office 365
Martin Machado
Jul, 2017 | 222 pages
Small book image
Mastering Office 365 Administration
Alara Rogers | Nikkia Carter | Thomas Carpe
May, 2018 | 532 pages
Small book image
Microsoft Office 365 Administration Cookbook
Nate Chamberlain
Sep, 2020 | 442 pages
Small book image
Office 365 Essentials
Nuno Arias Silva
May, 2018 | 394 pages
Table of Contents (16 chapters)
Title Page
Title Page
Credits
Credits
About the Authors
About the Authors
About the Reviewer
About the Reviewer
www.PacktPub.com
www.PacktPub.com
Customer Feedback
Customer Feedback
Preface
Preface
Free Chapter
1
PowerShell Fundamentals
PowerShell Fundamentals
Why do we need to learn PowerShell for Office 365?
PowerShell is a cmdlet based language with verb-noun syntax
How to pass parameters to cmdlets and storing results as a variable
How to get help with PowerShell
How PowerShell is an object-oriented language and how to work with objects
Using the if and where statements
Using the for and while loops
Creating your first script
Summary
2
Managing Office 365 with PowerShell
Managing Office 365 with PowerShell
Admin roles for Office 365
Installing and working with the Office 365 admin tools
Creating the first user account in PowerShell
Summary
3
Azure AD and Licensing Management
Azure AD and Licensing Management
Common administrative cmdlets that are used for managing accounts and licensing
How to change the license for existing users
Formatting data to be used for bulk account management
How to reset account passwords
How to update user account details
Summary
4
Managing SharePoint Online Using PowerShell
Managing SharePoint Online Using PowerShell
A brief overview of the SharePoint APIs
Setting up your environment
SharePoint Online scripting
Summary
5
Managing Exchange Online Using PowerShell
Managing Exchange Online Using PowerShell
Connecting to Exchange Online
Working with Exchange accounts
User impersonation
Role-based access control
Summary
6
Script Automation
Script Automation
PowerShell modules
Code signing
Active Directory Certificate Services
Summary
7
Patterns and Practices PowerShell
Patterns and Practices PowerShell
Why do we need to learn PnP PowerShell?
Installing and working with PnP PowerShell cmdlets
Using Windows Credential Manager with PnP PowerShell
Summary
8
OneDrive for Business
OneDrive for Business
Feature configuration
Personal site management
Data migration
Summary
9
PowerShell Core
PowerShell Core
Installing PowerShell Core
Remoting on PowerShell Core
Managing SharePoint with PowerShell Core
Managing SharePoint Online from PowerShell Core
Summary

Formatting data to be used for bulk account management

To create multiple users, assign licenses to multiple users, or do both at the same time, we can use data stored in a CSV file, text file, or even a SharePoint list.

In the following example, we will cover bulk user creation using a CSV file.

As mentioned previously, to create a new user the mandatory parameters are userprincipalname and DisplayName.

The CSV will need to be in the following format:

  • FirstName, LastName, Country
  • Bob, Smith, USA
  • Sanjay, Shah, UK

To implement this, we will need to connect to the Office 365 service first and import the input file; the next step is to store the info in variables, and the last step is to create the users in Office 365:

$users = Import-CSV "C:\Users.csv"
foreach ( $user in $users){
  $FirstName = $user.FirstName
  $LastName = $user.LastName
  $DisplayName = build it as per company policy
  $userName = build it as per company policy
  New-MSOLUser -UserPrincipalName $userName -DisplayName $DisplayName...
Previous Section
End of Section 4
Next Section