SPONSORED BY

DevOps with PowerShell for Office 365 and SharePoint Online

Gilles Pommier & Joelle RuelleOffice Server and Services MVPSmartView

SPONSORED BY

Hello I‘m Gilles

Montpellier, FRANCE smartview.fr Office365 MVP

Community Member gilles.pommier@smartview.fr http://www.smartview.fr

SPONSORED BY

Hello I‘m Joelle

Montpellier smartview.fr

RuelleJoelle

@RuelleJoelle Joelle.ruelle@smartview.fr

SPONSORED BY

Agenda

PowerShell and Office 365 : All you need to know

PowerShell & SharePoint DevOps

Demos, Demos, Demos

SPONSORED BY

Why Office 365 PowerShell ?

Additional

information that you

cannot see with the

Office 365 Admin

center

Features that you can

only configure by

using Office 365

PowerShell

bulk operations

Datas migration

ProvisionningEasy to print or

save data

Manage across

server products

SPONSORED BY

Multiple solutions to manage Office 365

Office 365 Management APIs• Programmatic access

• Innovate on top

PowerShell for Office 365• Automate and customize

• Advanced functions

Office 365 Admin Center• Out-of-the-box solution

• Simple but extensible

Office 365 Admin App• On-the-go solution

• Contextual

SPONSORED BY

What do you need ?

An tenant

Administrator privileges on your tenant

Administrator privileges on your machine running PowerShell

Administration modules

Microsoft Online Services Sign-in Assistant

Azure Active Directory Module

SharePoint Online Module

On-Premises

Farm Administrator

© Gokan Ozcifci

SPONSORED BY

Getting started

http://powershell.office.com/

Sets of samples, scenarios, guides, …

SPONSORED BY

DEMO 1Connect to Office 365 with PowerShell

SPONSORED BY

Office 365 Services with PowerShell

# Exchange Online$exchSession = New-PSSession `–ConfigurationName Microsoft.Exchange `-ConnectionUri https://ps.outlook.com/powershell `-Credential $c `-Authentication Basic `–AllowRedirectionImport-PSSession $exchSession –AllowClobber

# SharePoint Import-Module Microsoft.Online.Sharepoint.PowerShellConnect-SPOService -Url https://tenant-admin.sharepoint.com/ -Credential $c

Module Azure Active Directory (MSOnline)

# Skype for Business (aka Lync Online) Import-Module LyncOnlineConnector$skypeSession = New-CsOnlineSession -Credential $cImport-PSSession $skypeSession –AllowClobber

© Etienne Bailly

SPONSORED BY

DEMO 2Some PowerShell Office 365 use cases

Exchange Online

Skype

PowerBI (https://github.com/DevScope/powerbi-powershell-modules)

SPONSORED BY

PowerShell and SharePoint : identify the target

SPONSORED BY

Customization & automation for SharePoint Online

With the SharePoint Online

Module

With the SharePoint Client

Side Object Model (CSOM)

With the OfficeDev PnP

PowerShell Commands

With the SharePoint REST

APIs

With the Classical dev

solutions

SPONSORED BY

Rule #1 : organize your scripts

Project deployment Folder

Application Files Folder

Launcher

SPONSORED BY

Rule #2 - Think “SharePoint”

SPSite

SPWeb

SPList

SPListItem

SPONSORED BY

Office PnP-PowerShell : unlock the power

SPONSORED BY

SharePoint Online Module CmdLets

SPONSORED BY

Previously … CSOM

SPONSORED BY

Office PnP-PowerShell Commands : Where ?https://github.com/OfficeDev/PnP-PowerShell

SPONSORED BY

PnP-PowerShell commands : what?

SPONSORED BY

DEMO 3Office Dev PnP – PowerShell Commands

SPONSORED BY

Usefull Links

• Office 365 Dev PnP PowerShell CmdLets

• Windows PowerShell for SharePoint Command Builder

• Listing All SharePoint Server 2013 Features – Including Name, Title, Scope, ID and Description

• PowerShell Tools for Visual Studio

• PowerShell for Office 365

• Create a Real-Time IT Dashboard with PowerBIPS

SPONSORED BY

Thanks !