Note <\/b>All scripts from today's post are available in the Script Center Repository:<\/p>\n The SharePoint Online Management Shell<\/a> has been out for a while now, allowing you to script some tasks with your Office 365 deployment. It lets you use Windows PowerShell to create site collections, work with users and groups, and upgrade site collections in SharePoint Online. However, if you are used to working with Windows PowerShell for SharePoint 2013 on-premises, you will notice that a number of common tasks are missing such as creating sites or enabling features.<\/p>\n Luckily, we can make use of the Client Script Object Model (CSOM) in Windows PowerShell to accomplish some of these tasks. Today, we're going to look at creating sites, deleting sites, and getting a list of sites in SharePoint Online. It takes a few more lines of script, but this post will get you started.<\/p>\n To work with CSOM in SharePoint Online, we need access to the client assemblies. You can either download the SharePoint Server 2013 Client Components SDK<\/a>, or you can get the assemblies from a local SharePoint 2013 installation. You don't need to run your Windows PowerShell script on a SharePoint server. It will work from Windows 7 with SP1 or later.<\/p>\n After you have located the assemblies, we need to load them in our script. We can do this a number of ways. If you are working directly on your SharePoint server, you can use LoadWithPartialName<\/b>:<\/p>\n [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client")<\/p>\n [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client.Runtime")<\/p>\n However, if you copied the assemblies manually somewhere, you might want to use Add-Type<\/b>:<\/p>\n Add-Type -Path "c:\\folder\\Microsoft.SharePoint.Client.dll"<\/p>\n Add-Type -Path "c:\\folder\\Microsoft.SharePoint.Client.Runtime.dll"<\/p>\n We'll add these types to all of our scripts today.<\/p>\n After referencing our assemblies, we need to authenticate to SharePoint Online and get a ClientContext<\/a> object. We use similar command when working with the Managed Client Object Model for SharePoint.<\/p>\n First, store the path to the site collection we want to work with, in addition to the user name. Be sure to specify a user name that has permission to create sites. If you prefer, you could request all of these variables as parameters to your script.<\/p>\n $siteUrl = “https:\/\/mytenant.sharepoint.com\/sites\/mysitecollection”<\/p>\n $username = "admin@mytenant.onmicrosoft.com"<\/p>\n Now, we need to read the password. The easiest way to do this is with Read-Host<\/b> and the AsSecureString<\/b> parameter. When you run the script, you will be prompted to type the password.<\/p>\n $password = Read-Host -Prompt "Enter password" -AsSecureString<\/p>\n We have everything we need to get a ClientContext<\/b> now. Initialize a new one by using New-Object<\/b> and pass it to $siteUrl<\/b>. We’ll name ours $ctx<\/b>.<\/p>\n $ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)<\/p>\n Then we need to add the credentials by using the SharePointOnlineCredentials<\/a> object, and pass $username<\/b> and $password<\/b> as parameters. Then, we assign $credentials<\/b> to the ClientContext<\/b> object.<\/p>\n $credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($username, $password)<\/p>\n $ctx.Credentials = $credentials<\/p>\n At this point, we can use our ClientContext<\/b> object to create, delete, and retrieve a list of sites. We’ll use the previous lines in all of our scripts.<\/p>\n In our first example, we’ll start with a script to create a site. The beginning of the script will contain the assembly references and authentication script we showed above. When creating a site, we use the WebCreationInformation<\/a> object.<\/p>\n In the following script, I specify a relative URL to the site collection and a title. The WebTemplate<\/b> parameter takes any supported web template in SharePoint Online. You can get a list of these by using SharePoint Online Management Shell and the Get-SPOWebTemplate<\/a> cmdlet. In the following example, I am using the Team Site template, which is STS#0<\/b>.<\/p>\n $webCreationInformation = New-Object Microsoft.SharePoint.Client.WebCreationInformation<\/p>\n $webCreationInformation.Url = "site1"<\/p>\n $webCreationInformation.Title = "Site 1"<\/p>\n $webCreationInformation.WebTemplate = "STS#0"<\/p>\n $newWeb = $ctx.Web.Webs.Add($webCreationInformation)<\/p>\n We then pass the WebCreationInformation<\/b> object to the Webs<\/b> collection, which we find on our ClientContext.Web object.<\/p>\n If you have used the Client Object Model before, you know you aren’t done yet. You need to call ClientContext.Load() <\/b>with $newWeb<\/b>. We follow this with ClientContext.ExecuteQuery()<\/b>.<\/p>\n $ctx.Load($newWeb)<\/p>\n $ctx.ExecuteQuery()<\/p>\n This will send the request to SharePoint and your site will be created. Running the script won’t yield any output.<\/p>\n You might be tempted to add a $newWeb<\/b> statement after the script executes. However, this will give you the following error message:<\/p>\n format-default<\/b> : The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.<\/p>\n That’s because, the Web<\/a> object contains a number of collections that also need to be loaded explicitly by using ClientContext.Load<\/b>. However, you can request properties such as the Title<\/b> or Url<\/b>.<\/p>\n Write-Host "Title" $newWeb.Title<\/p>\n Here is what the entire script looks like to create a site in SharePoint Online:<\/p>\n Add-Type -Path "c:\\folder\\Microsoft.SharePoint.Client.dll"<\/p>\n Add-Type -Path "c:\\folder\\Microsoft.SharePoint.Client.Runtime.dll"<\/p>\n <\/p>\n $siteUrl = “https:\/\/mytenant.sharepoint.com\/sites\/mysitecollection”<\/p>\n $username = "admin@mytenant.onmicrosoft.com"<\/p>\n $password = Read-Host -Prompt "Enter password" -AsSecureString<\/p>\n $ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)<\/p>\n $credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($username, $password)<\/p>\n $ctx.Credentials = $credentials<\/p>\n <\/p>\n $webCreationInformation = New-Object Microsoft.SharePoint.Client.WebCreationInformation<\/p>\n $webCreationInformation.Url = "site1"<\/p>\n $webCreationInformation.Title = "Site 1"<\/p>\n $webCreationInformation.WebTemplate = "STS#0"<\/p>\n $newWeb = $ctx.Web.Webs.Add($webCreationInformation)<\/p>\n <\/p>\n $ctx.Load($newWeb)<\/p>\n $ctx.ExecuteQuery()<\/p>\n $newWeb<\/p>\n Write-Host "Title" $newWeb.Title<\/p>\n To delete a site, the process is fairly similar. Instead of setting the ClientContext<\/b> URL to the site collection, set it to the site that you want to delete:<\/p>\n $siteUrl = “https:\/\/mytenant.sharepoint.com\/sites\/sitecollection\/site1”<\/p>\n After we add the script for the references and authentication, get a reference to ClientContex.Web<\/b>, load it, and call ExecuteQuery()<\/b>.<\/p>\n $web = $ctx.Web<\/p>\n $ctx.Load($web)<\/p>\n $ctx.ExecuteQuery()<\/p>\n Finally, call the Web.DeleteObject method<\/a> to delete the site. This will require an additional call to ExecuteQuery<\/b> to finalize the deletion.<\/p>\n $web.DeleteObject()<\/p>\n $ctx.ExecuteQuery()<\/p>\n At this point, the site has been deleted.<\/p>\n Here is the complete script for deleting a site in SharePoint Online:<\/p>\n Add-Type -Path "c:\\folder\\Microsoft.SharePoint.Client.dll"<\/p>\n Add-Type -Path "c:\\folder\\Microsoft.SharePoint.Client.Runtime.dll"<\/p>\n <\/p>\n $siteUrl = “https:\/\/mytenant.sharepoint.com\/sites\/mysitecollection\/site1”<\/p>\n $password = Read-Host -Prompt "Enter password" -AsSecureString<\/p>\n $ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)<\/p>\n $credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials("admin@mytenant.onmicrosoft.com", $password)<\/p>\n $ctx.Credentials = $credentials<\/p>\n <\/p>\n $web = $ctx.Web<\/p>\n <\/p>\n $ctx.Load($web)<\/p>\n $ctx.ExecuteQuery()<\/p>\n <\/p>\n $web.DeleteObject()<\/p>\n $ctx.ExecuteQuery()<\/p>\n Write-Host $web.Title "Site Deleted"<\/p>\n Retrieving a list of sites is a bit more complicated, because of the load requirements around the Web<\/b> object. Chris O'Brien's post, Using CSOM in PowerShell scripts with Office 365<\/a>, pointed me in the right direction to make this work. In this script, we’ll return all subsites of the site collection in SharePoint Online. We’ll start the script by using the same script as before to add references and authentication.<\/p>\n Start by getting a reference to the root web of the site collection:<\/p>\n $rootWeb = $ctx.Web<\/p>\n Next, we use the Webs property<\/a> of the Web<\/b> object to get the list of all subsites. We then need to load both these objects and call ClientContext.ExecuteQuery()<\/b>.<\/p>\n $ctx.Load($rootWeb)<\/p>\n $ctx.Load($sites)<\/p>\n $ctx.ExecuteQuery()<\/p>\n Unfortunately, you can’t simply call $sites<\/b> to see a nice list. You need to iterate through each subsite and use ClientContext.Load<\/b> and ClientContext.ExecuteQuery()<\/b> to populate the values. That means the script makes a round-trip to the server once for each site, which is not exactly efficient. Here’s how we iterate through the sites and write out the Title<\/b> and Url<\/b> properties:<\/p>\n foreach($site in $sites)<\/p>\n {<\/p>\n $ctx.Load($site)<\/p>\n $ctx.ExecuteQuery()<\/p>\n <\/p>\n Write-Host $site.Title "-" $site.Url<\/p>\n }<\/p>\n The script looks like this when executed:<\/p>\n You’ll notice this returns all subsites including those used by apps. That’s why you see Yammer in the list. You could write additional script to filter that, if desired.<\/p>\n Here is the complete script to get all sites in a site collection from SharePoint Online:<\/p>\n Add-Type -Path "c:\\folder\\Microsoft.SharePoint.Client.dll"<\/p>\n Add-Type -Path "c:\\folder\\Microsoft.SharePoint.Client.Runtime.dll"<\/p>\n <\/p>\n $siteUrl = "https:\/\/mytenant.sharepoint.com\/sites\/mysitecollection"<\/p>\n $password = Read-Host -Prompt "Enter password" -AsSecureString<\/p>\n $ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)<\/p>\n $credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials("admin@mytenant.onmicrosoft.com", $password)<\/p>\n $ctx.Credentials = $credentials<\/p>\n <\/p>\n $rootWeb = $ctx.Web<\/p>\n $sites = $rootWeb.Webs<\/p>\n <\/p>\n $ctx.Load($rootWeb)<\/p>\n $ctx.Load($sites)<\/p>\n $ctx.ExecuteQuery()<\/p>\n <\/p>\n foreach($site in $sites)<\/p>\n {<\/p>\n $ctx.Load($site)<\/p>\n $ctx.ExecuteQuery()<\/p>\n <\/p>\n Write-Host $site.Title "-" $site.Url<\/p>\n }<\/p>\n By using the Client Script Object Model, you can automate more tasks in SharePoint Online. If you are going to be at TechEd North America this year, be sure to check out my session, Windows PowerShell 3.0 Administration with Microsoft SharePoint 2013 and SharePoint Online (OFC-B328). We’ll cover this example and more for SharePoint Online and SharePoint on-premises.<\/p>\n ~Corey<\/p>\n Note <\/b>Corey has also agreed to be a special guest at the Scripting Guys booth at TechEd. So that will be a great time to meet with Corey and to have all your Windows PowerShell and SharePoint questions answered. WooHoo!<\/p>\n Thank you, Corey, for sharing this. Join me tomorrow when I will talk about more cool Windows PowerShell stuff.<\/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<\/strong> <\/p>\n","protected":false},"excerpt":{"rendered":" Summary: Guest blogger, Corey Roth, talks about using Windows PowerShell to create and manage SharePoint online sites. Microsoft Scripting Guy, Ed Wilson, is here. Today we have a guest post by SharePoint MVP, Corey Roth. Corey will be presenting at TechEd 2014 this year in Houston, and he has taken the time to share his thoughts […]<\/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":[505,3,59,45],"class_list":["post-1541","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-deployment-and-upgrade","tag-scripting-guy","tag-sharepoint","tag-windows-powershell"],"acf":[],"blog_post_summary":" Summary: Guest blogger, Corey Roth, talks about using Windows PowerShell to create and manage SharePoint online sites. Microsoft Scripting Guy, Ed Wilson, is here. Today we have a guest post by SharePoint MVP, Corey Roth. Corey will be presenting at TechEd 2014 this year in Houston, and he has taken the time to share his thoughts […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/1541","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=1541"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/1541\/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=1541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=1541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=1541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
Getting started<\/h2>\n
Authentication<\/h2>\n
Creating sites<\/h2>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/hsg-4-24-14-1.png\" "\\"Image")
<\/a><\/p>\nComplete script<\/h3>\n
Deleting sites<\/h2>\n
Complete script<\/h3>\n
Getting a list of sites<\/h2>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/hsg-4-24-14-2.png\" "\\"Image")
<\/a><\/p>\nComplete script<\/h3>\n