SPO - Management & Operations with PowerShell

1. SPO - Management & Operations with PowerShell Office 365: SharePoint Online 31 May 2014 Jason Kaczor SharePoint Consultant/Architect – MVP Illumination Industries Ltd.

2. About Me – Jason Kaczor jason@kaczor.ca http://jason.kaczor.ca +1(403)827-7276

3. Session Agenda • Office 365 & SPO Fundamentals • Getting Started • Basics • Scenarios & Tasks • Problems & Limitations • Extensions • Resources • Questions & Answers

5. Office 365 & SPOFundamentals

6. High-level Office 365 Architecture Exchange Online Authentication platform Trust Customer Premises Active Directory Federation Server 2.0 Admin Portal/ PowerShell IdP SharePoint Online IdP Directory Store Provisioning platform MS Online Directory Sync AD Lync Online

7. SharePoint Online Administration

8. Getting Started

9. SPO PowerShell Tooling Client/Desktop Operating System Windows Server 2012, Windows Server 2008 R2 SP1, Windows 8, Windows 7 SP1 .NET Framework 4.5 (4.5.2) Microsoft Online Services Sign-in Assistant for IT Professionals RTW All Latest OS Updates Windows Management Framework 3.0 (PowerShell 3.0) Windows Azure AD Module for Windows PowerShell 32-bit Windows Azure AD Module for Windows PowerShell 64-bit SharePoint Online Management Shell

10. SPO PowerShell Configuration • Set-ExecutionPolicy • Run-As Administrator

11. SPO PowerShell ISE Configuration

12. Basics

13. Connecting to SPO • Connect-SPOService • Connects to SharePoint Online • -Url – URL to SharePoint Online tenant administration • i.e.: https://mytenant-admin.sharepoint.com • -Credential – complete username of a global administrator • i.e.: admin@mytenant.onmicrosoft.com Connect-SPOService –Url https://mytenant-admin.sharepoint.com –Credential admin@mytenant.onmicrosoft.com

14. Available SPO commands • get-command -noun spo* | Group Noun • SPOUser{Add-SPOUser, Get-SPOUser, Remove-SPOUser, Set-SPOUser} • SPOService {Connect-SPOService, Disconnect-SPOService} • SPOAppErrors {Get-SPOAppErrors} • SPOAppInfo {Get-SPOAppInfo} • SPODeletedSite {Get-SPODeletedSite, Remove-SPODeletedSite, Restore-SPODeletedSite} • SPOExternalUser {Get-SPOExternalUser, Remove-SPOExternalUser} • SPOSite {Get-SPOSite, New-SPOSite, Remove-SPOSite, Repair-SPOSite...} • SPOSiteGroup {Get-SPOSiteGroup, New-SPOSiteGroup, Remove-SPOSiteGroup, Set-SPOSiteGroup} • SPOTenant {Get-SPOTenant, Set-SPOTenant} • SPOTenantLogEntry {Get-SPOTenantLogEntry} • SPOTenantLogLastAvaila... {Get-SPOTenantLogLastAvailableTimeInUtc} • SPOWebTemplate {Get-SPOWebTemplate} • SPOUpgradeEvaluationSite {Request-SPOUpgradeEvaluationSite} • Index of Windows PowerShell for SharePoint Online cmdlets

15. Available SPO commands • get-command –module Microsoft.Online.SharePoint.PowerShell • Request-SPOUpgradeEvaluationSite • Get-SPOTenant • Get-SPOTenantLogEntry • Get-SPOTenantLogLastAvailableTimeInUtc • Set-SPOTenant • Connect-SPOService • Disconnect-SPOService • Get-SPOAppErrors • Get-SPOAppInfo • Get-SPODeletedSite • Add-SPOUser • Get-SPOExternalUser • Get-SPOUser • Remove-SPOExternalUser • Remove-SPOUser • Set-SPOUser • Get-SPOSiteGroup • Remove-SPOSiteGroup • New-SPOSiteGroup • Set-SPOSiteGroup • Get-SPOSite • New-SPOSite • Remove-SPODeletedSite • Remove-SPOSite • Repair-SPOSite • Restore-SPODeletedSite • Set-SPOSite • Get-SPOWebTemplate • Test-SPOSite • Upgrade-SPOSite

16. Scenarios & Tasks

17. Working with Site Collections • Get-SPOSite • Returns one or more site collections • -Identity (optional) – URL of site collection • -Limit (optional) – number of site collections to return • Default 200, ALL can be used Get-SPOSite Get-SPOSite -Detailed Get-SPOSite –Identity https://mytenant.sharepoint.com Get-SPOSite –Filter {Url -like “*term*}

18. Creating new Site Collections • New-SPOSite • Creates a site collection • -Url – full URL of new site collection • -Owner – full user name of site owner • i.e.: admin@mytenant.onmicrosoft.com New-SPOSite -Url https://mytenant.sharepoint.com/sites/mynewsite -Owner user@domain.com -StorageQuota 1000 -Title "My new site collection“ –Template STS#0

19. Deleting Site Collections • Remove-SPOSite • Moves site collection to recycle bin • -Identity – URL of site collection • Supports –confirm and -NoWait Remove-SPOSite –Identity http://mytenant.sharepoint.com/sites/sitename -NoWait

20. Restoring Site Collections • Restore-SPODeletedSite • Restores a site collection from the recycle bin • -Identity – URL of site collection Restore-SPODeletedSite –Identity http://mytenant.sharepoint.com/sites/sitename -NoWait

21. Modifying Site Collections • Set-SPOSite • Sets or updates properties of a site collection • -Identity – URL of site collection Set-SPOSite –Identity http://mytenant.sharepoint.com/sites/sitename -NoWait

22. Upgrading Site Collections • Test-SPOSite • -Identity – URL of site collection • Upgrade-SPOSite • -Identity – URL of site collection • -V2VUpgrade – Required to do a version upgrade Test-SPOSite -Identity http://mytenant.sharepoint.com/sites/sitename Upgrade-SPOSite -Identity http://mytenant.sharepoint.com/sites/sitename -V2VUpgrade

23. Working with Users • Get-SPOUser • -Site – full URL of site collection • Add-SPOUser • Adds existing user to a SharePoint Group • -Site – full URL of site collection • -LoginName – specific user account name • -Group – SharePoint group Get-SPOUser -Site https://mytenant.sharepoint.com -LoginName user@domain.com Add-SPOUser -Site https://mytenant.sharepoint.com -LoginName user@domain.com -Group "Team Site Members“

24. Working with External Users • Get-SPOExternalUser • Remove-SPOExternalUser $user = Get-SPOExternalUser -Filter user@domain.com Remove-SPOExternalUser -UniqueIDs @($user.UniqueId)

25. Logs • Get-SPOTenantLogLastAvailableTimeInUtc • Get-SPOTenantLogEntry • Get-SPOAppErrors

26. Demo

27. Problems & Limitations

28. Missing functionality… • Administration & manipulation of… • Features • Properties • Content Types • Lists, Libraries, Items & Folders • Taxonomy, Terms & Managed Metadata • Search

29. Extensions

30. Extensions – Gary LaPointe • http://blog.falchionconsulting.com/index.php/downloads/ • Disable-SPOFeature • Enable-SPOFeature • Get-SPOFeature • Get-SPOFile • Get-SPOFolder • Get-SPOList • New-SPOFile • New-SPOList • New-SPOListFolder • New-SPOListItem • Remove-SPOList • Set-SPOList • Get-SPOContentType • Get-SPOEventReceiver • Export-SPOTaxonomy • Get-SPOTerm • Get-SPOTermGroup • Get-SPOTermSet • Get-SPOTermStore • Import-SPOTaxonomy • New-SPOTermGroup • New-SPOTermSet • Export-SPOSearchConfiguration • Import-SPOSearchConfiguration • Get-SPOContextSite • Get-SPOWeb • New-SPOWeb • Remove-SPOWeb • Set-SPOWeb • Set-SPOWebTheme

31. Extensions – SPO Automation • http://sharepointonlineautomationcmdlets.codeplex.com/ • ExportMMS • SetMMSField • AddSPOListCT • NewSPOList • RemoveSPOList • SetLookupField • PublishSPOFiles • PublishSPOFile • ImportSPOListItemsFromCSV • SetSPOListItemField • RemoveAllCTFromList • ImportSPOSearchConfig • SPOWebClient • InstallSPOWebFeature • UnintallSPOFeature • InstallSPOSiteFeature • UninstallSPOSiteFeature • AddSPONavigationItem • ClearSPONavigation • GetSPONavigation • SetSPONavigationInherits • RemoveSPONavigationNodesByName • AddSPOSolution • AddSPDesignPackage • InstallSPOSolution • UninstallSPOSolution • UpdateSPOSolution • NewSPOWeb • GetSPOWeb • RemoveAllSPOWebs

32. Resources • Office • Introduction to the SharePoint Online Management Shelll • Technet • Windows PowerShell for SharePoint Online • Windows PowerShell for SharePoint Command Builder

33. Questions & Answers {Something to say?}

34. Thanks to Our Sponsors

35. Special Thanks • SharePoint Training Courses • http://www.neweratechnology.com/courses/sharepoint.aspx CalSPUG Calgary SharePoint User Group

36. Housekeeping • Join us for SharePint • Time: 4:15 PM – 6:00 PM • Location: TBD