{"id":5421,"date":"2015-06-21T00:01:00","date_gmt":"2015-06-21T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2015\/06\/21\/weekend-scripter-start-powershell-scripting-for-office-365-sites\/"},"modified":"2019-02-18T09:47:21","modified_gmt":"2019-02-18T16:47:21","slug":"weekend-scripter-start-powershell-scripting-for-office-365-sites","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/weekend-scripter-start-powershell-scripting-for-office-365-sites\/","title":{"rendered":"Weekend Scripter: Start PowerShell Scripting for Office 365 Sites"},"content":{"rendered":"

Summary<\/strong>: Guest blogger, Michael Blumenthal shows how to findWindows PowerShell cmdlets that are available for <\/span>Office 365 sites<\/span>.<\/span><\/p>\n

Microsoft Scripting Guy, Ed Wilson, is here. Today we have a new guest blogger, Michael Blumenthal, who we met in Chicago in May at Microsoft Ignite. Here is a little bit about Michael:<\/p>\n

\"Photo<\/a><\/p>\n

Michael Blumenthal is a technical solution evangelist with PSC Group <\/a>and a Microsoft Office 365 MVP<\/a>. As such, he is an experienced architect for SharePoint, and business technology advisor. Michael has deep SharePoint expertise, with two decades of development, infrastructure, and administration experience. He’s designed, implemented, and supported intranets, extranets, and Internet sites for clients in markets as diverse as banking, energy, government, and transportation.<\/p>\n

Michael holds numerous Microsoft certifications (including most of the SharePoint certifications) and the Certified Associate in Project Management (CAPM) from the Project Management Institute. He can be found year round speaking on technology topics, including SharePoint and Windows PowerShell, at Chicago-area technology events and user groups.<\/p>\n

Michael's contact info:<\/p>\n

Blog<\/b>: Michael Blumenthal, Office 365 MVP<\/a>
Twitter<\/b>: @michaelbl<\/a><\/p>\n

You need Windows PowerShell 4.0<\/h2>\n

I assume you already have Windows PowerShell 4.0 installed. You will want two cmdlet libraries:<\/p>\n

First, get the SharePoint Online Management Shell<\/a> and install it. This will give you…wait for it…<\/p>\n

37 SharePoint Online cmdlets.<\/p>\n

I counted them this way:<\/p>\n

get-command -Noun SPO* | where moduleName -like Microsoft.Online.SharePoint* | measure<\/p>\n

Thirty-seven? Yes, only 37! But in SharePoint 2013 on premise, I had hundreds of SharePoint cmdlets available to me. What on earth will I do?<\/p>\n

First, let’s look at what these 37 are:<\/p>\n

PS C:\\Windows\\system32> get-command -Noun SPO* | where moduleName -like Microsoft.Online.SharePoint* |
Select-Object Name | Sort-Object Name<\/p>\n

Name<\/p>\n

—-<\/p>\n

Add-SPOUser<\/p>\n

Connect-SPOService<\/p>\n

ConvertTo-SPOMigrationTargetedPackage<\/p>\n

Disconnect-SPOService<\/p>\n

Get-SPOAppErrors<\/p>\n

Get-SPOAppInfo<\/p>\n

Get-SPODeletedSite<\/p>\n

Get-SPOExternalUser<\/p>\n

Get-SPOSite<\/p>\n

Get-SPOSiteGroup<\/p>\n

Get-SPOTenant<\/p>\n

Get-SPOTenantLogEntry<\/p>\n

Get-SPOTenantLogLastAvailableTimeInUtc<\/p>\n

Get-SPOTenantSyncClientRestriction<\/p>\n

Get-SPOUser<\/p>\n

Get-SPOWebTemplate<\/p>\n

New-SPOMigrationPackage<\/p>\n

New-SPOSite<\/p>\n

New-SPOSiteGroup<\/p>\n

Remove-SPODeletedSite<\/p>\n

Remove-SPOExternalUser<\/p>\n

Remove-SPOSite<\/p>\n

Remove-SPOSiteGroup<\/p>\n

Remove-SPOTenantSyncClientRestriction<\/p>\n

Remove-SPOUser<\/p>\n

Repair-SPOSite<\/p>\n

Request-SPOPersonalSite<\/p>\n

Request-SPOUpgradeEvaluationSite<\/p>\n

Restore-SPODeletedSite<\/p>\n

Set-SPOSite<\/p>\n

Set-SPOSiteGroup<\/p>\n

Set-SPOTenant<\/p>\n

Set-SPOTenantSyncClientRestriction<\/p>\n

Set-SPOUser<\/p>\n

Submit-SPOMigration<\/p>\n

Test-SPOSite<\/p>\n

Upgrade-SPOSite<\/p>\n

What about missing cmdlets?<\/h2>\n

What? No SPOWeb<\/b>? Well, let’s get more cmdlets then! Gary LaPointe to the rescue! Go to APTILLON Sharepoint Automation<\/a> and click Installer: Lapointe.SharePointOnline.PowerShell.msi<\/a>.<\/p>\n

Run that.<\/p>\n

Now how many cmdlets do you have?<\/p>\n

get-command -Noun SPO* | where moduleName -like Lapointe.SharePointOnline.* | measure<\/p>\n

45! Yay! What are they?<\/p>\n

PS C:\\Windows\\system32> get-command -Noun SPO* | where moduleName -like Lapointe.SharePointOnline.* |
Select-Object Name | Sort-Object Name<\/p>\n

Name<\/p>\n

—-<\/p>\n

Add-SPOContentType<\/p>\n

Add-SPOField<\/p>\n

Add-SPOListViewWebPart<\/p>\n

Add-SPOSolution<\/p>\n

Add-SPOWebPart<\/p>\n

Connect-SPOSite<\/p>\n

Disable-SPOFeature<\/p>\n

Disconnect-SPOSite<\/p>\n

Enable-SPOFeature<\/p>\n

Export-SPOSearchConfiguration<\/p>\n

Export-SPOTaxonomy<\/p>\n

Get-SPOContentType<\/p>\n

Get-SPOContextSite<\/p>\n

Get-SPOEventReceiver<\/p>\n

Get-SPOFeature<\/p>\n

Get-SPOFile<\/p>\n

Get-SPOFolder<\/p>\n

Get-SPOList<\/p>\n

Get-SPOTerm<\/p>\n

Get-SPOTermGroup<\/p>\n

Get-SPOTermSet<\/p>\n

Get-SPOTermStore<\/p>\n

Get-SPOWeb<\/p>\n

Get-SPOWebPart<\/p>\n

Import-SPOSearchConfiguration<\/p>\n

Import-SPOTaxonomy<\/p>\n

Install-SPOSolution<\/p>\n

Invoke-SPORestMethod<\/p>\n

New-SPOContentType<\/p>\n

New-SPOField<\/p>\n

New-SPOFile<\/p>\n

New-SPOList<\/p>\n

New-SPOListFolder<\/p>\n

New-SPOListItem<\/p>\n

New-SPOTermGroup<\/p>\n

New-SPOTermSet<\/p>\n

New-SPOWeb<\/p>\n

New-SPOWikiPage<\/p>\n

Remove-SPOContentType<\/p>\n

Remove-SPOList<\/p>\n

Remove-SPOWeb<\/p>\n

Set-SPOList<\/p>\n

Set-SPOWeb<\/p>\n

Set-SPOWebTheme<\/p>\n

Set-SPOWikiPageLayout<\/p>\n

Even more SharePoint cmdlets<\/h2>\n

Ah, that’s more like it! Cmdlets to work with lists and libraries. Now we’re talking!<\/p>\n

However, if you want more cmdlets and some examples, take a look at this CodePlex project: Client-side SharePoint PowerShell<\/a>.<\/p>\n

Now that we have the cmdlets in the SharePoint Online Management Console and the cmdlets from Gary LaPointe, we can do things like this:<\/p>\n

function global:Get-SPOWebInfo {<\/p>\n

<#<\/p>\n

.SYNOPSIS<\/p>\n

         This demonstrates the use of some cmdlets for Office 365 Sites.<\/p>\n

    .DESCRIPTION<\/p>\n

         This demonstrates the use of some cmdlets for Office 365 Sites using both Microsoft's and Gary LaPointe's cmdlets for SharePoint Online.<\/p>\n

    .PARAMETER TenantAdminURL<\/p>\n

        The Admin URL for your O365 Tenant.  For example, if your tenant is https:\/\/foo.sharepoint.com, your Admin URL is https:\/\/foo-admin.sharepoint.com.<\/p>\n

    .PARAMETER  Login<\/p>\n

        Your O365 login email.<\/p>\n

    .PARAMETER  Password<\/p>\n

        Your O365 login password.<\/p>\n

    .EXAMPLE<\/p>\n

     get-SPOWebInfo -TenantAdminURL foo.sharepoint.com -Login login@somedomain.com -password SomeStrongPasswordGoesHere <\/p>\n

     .OUTPUTS<\/p>\n

         Writes out the URL of every web in every site.<\/p>\n

    .NOTES<\/p>\n

         Author: Michael Blumenthal, PSC Group LLC<\/p>\n

#><\/p>\n

Param<\/p>\n

          (<\/p>\n

            [parameter(Mandatory=$true, HelpMessage="Enter the Admin URL for your O365 tenant.")]<\/p>\n

            [Uri]<\/p>\n

            $TenantURL,<\/p>\n

             [parameter(Mandatory=$true, HelpMessage="Enter your admin login.")]<\/p>\n

            [System.String]<\/p>\n

            $Login,<\/p>\n

            [System.Security.SecureString][Parameter(Mandatory=$true, HelpMessage="Enter your super secret strong password.")]<\/p>\n

            $password<\/p>\n

          ) <\/p>\n

    $credential = new-object -typename System.Management.Automation.PSCredential -argumentlist $Login, $password<\/p>\n

    Connect-SPOService -Url $TenantURL -Credential $credential <\/p>\n

     $SiteCollections = Get-SPOSite -Detailed<\/p>\n

     foreach ($SiteCollection in $SiteCollections)<\/p>\n

     {<\/p>\n

      write-host $SiteCollection.Url -foregroundcolor Blue <\/p>\n

            $rootwebUrl = $SiteCollection.Url<\/p>\n

            try {<\/p>\n

                Connect-SPOSite -Credential $credential -Url $rootwebURL <\/p>\n

                $allwebs = Get-SPOWeb -Detail <\/p>\n

                #each web is a Microsoft.SharePoint.Client.Web<\/p>\n

          foreach ($web in $allwebs)<\/p>\n

          { <\/p>\n

                    write-host "In " $web.Title "at" $web.Url           <\/p>\n

                }<\/p>\n

            }<\/p>\n

            Catch [Microsoft.SharePoint.Client.ServerUnauthorizedAccessException] {<\/p>\n

                Write-Host -ForegroundColor Yellow "SUAE error."<\/p>\n

            }<\/p>\n

            Catch [System.Net.WebException] {<\/p>\n

                Write-Host -ForegroundColor Yellow "WebException."<\/p>\n

                Write-Host -ForegroundColor Yellow $_.exception.Message<\/p>\n

            }<\/p>\n

            Catch {<\/p>\n

                $ErrorMessage = $_.Exception.Message<\/p>\n

                $FailedItem = $_.Exception.ItemName<\/p>\n

                $ExceptionType = $_.Exception.GetType().FullName;<\/p>\n

                Write-host -ForegroundColor Yellow "Other exception: " $ExceptionType<\/p>\n

                Write-host -ForegroundColor Yellow Message: $ErrorMessage<\/p>\n

                Write-host -ForegroundColor Yellow Failed Item $FailedItem<\/p>\n

            }<\/p>\n

     }<\/p>\n

    Disconnect-SPOService <\/p>\n

}<\/p>\n

get-command Get-SPOWebInfo <\/p>\n

 Let's check it out<\/h2>\n

Now run Get-SPOWebInfo<\/b>, and give it a try!<\/p>\n

\"Image<\/a><\/p>\n

~Michael<\/p>\n

Thank you, Michael. Great introduction to finding and using SharePoint cmdlet resources.<\/p>\n

I invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n

Ed Wilson, Microsoft Scripting Guy<\/b> <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Guest blogger, Michael Blumenthal shows how to findWindows PowerShell cmdlets that are available for Office 365 sites. Microsoft Scripting Guy, Ed Wilson, is here. Today we have a new guest blogger, Michael Blumenthal, who we met in Chicago in May at Microsoft Ignite. Here is a little bit about Michael: Michael Blumenthal is a […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[56,593,291,594,3,595,61,45],"class_list":["post-5421","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-guest-blogger","tag-michael-blumenthal","tag-office-365","tag-office-365-sites","tag-scripting-guy","tag-sharepoint-online","tag-weekend-scripter","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Guest blogger, Michael Blumenthal shows how to findWindows PowerShell cmdlets that are available for Office 365 sites. Microsoft Scripting Guy, Ed Wilson, is here. Today we have a new guest blogger, Michael Blumenthal, who we met in Chicago in May at Microsoft Ignite. Here is a little bit about Michael: Michael Blumenthal is a […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/5421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=5421"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/5421\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=5421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=5421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=5421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}