Using the new PnP Provisioning Engine, you can model a site by configuring the design of Site Columns, Content Types, List Definitions and Instances, Composed Looks, Pages (either WebPart Pages or Wiki Pages), and much more, via your web browser. When you are done with the design, you can export what you have done into Read more about Export-Apply Site Template using PnP Provisioning Engine[…]
So here is a very useful code that I found which is very useful when you want to estimate a migration activity. This code will help you get information of sites from SharePoint Online namely Lists and Libraries, Item Count etc. Reference Link: http://www.sharepointfire.com/2016/01/get-site-web-and-list-information-with-powershell-for-sharepoint-online/ Code:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 |
function connectToO365{ # Let the user fill in their admin url, username and password $adminUrl = Read-Host "Enter the Admin URL of 0365 (eg. https://<Tenant Name>-admin.sharepoint.com)" $userName = Read-Host "Enter the username of 0365 (eg. admin@<tenantName>.onmicrosoft.com)" $password = Read-Host "Please enter the password for $($userName)" -AsSecureString # set credentials $credentials = New-Object -TypeName System.Management.Automation.PSCredential -argumentlist $userName, $password $SPOCredentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($userName, $password) #connect to to Office 365 try{ Connect-SPOService -Url $adminUrl -Credential $credentials write-host "Info: Connected succesfully to Office 365" -foregroundcolor green } catch{ write-host "Error: Could not connect to Office 365" -foregroundcolor red Break connectToO365 } #create HTML file $filePath = create-outputfile #start getting site collections get-siteCollections add-content -value " </body> </html> " -path $filePath } function create-outputfile(){ #Create unique string from the date $date = get-date -format dMMyyyyhhmm #set the full path $filePath = "$($PSScriptRoot)\Output$($date).html" #test path if (!(Test-Path -path $filePath)){ #create file New-Item $filePath -type file | out-null #print info write-host “File created: $($filePath)” -foregroundcolor green #add start HTML information to file add-content -value " <html> <body> <h1>Sites information Office 365</h1> <table border='1' style='font-family: Calibri, sans-serif'> <tr> <th style='background-color:blue; color:white'>URL</th> <th style='background-color:blue; color:white'>Type</th> <th style='background-color:blue; color:white'>Template</th> <th style='background-color:blue; color:white'>Item Count</th> </tr> " -path $filePath } else{ #break so there won't be duplicate files write-host "Output file already exists, wait 1 minute" -foregroundcolor yellow Break create-outputfile } return $filePath } function get-siteCollections{ #Get all site collections $siteCollections = Get-SPOSite #loop through all site collections foreach ($siteCollection in $siteCollections) { #set variable for a tab in the table $pixelsweb = 0 $pixelslist = 0 #add info to HTML document add-content -value "<tr style='background-color:cyan'><td>$($siteCollection.url)</td><td>TopSite</td><td>$($sitecollection.template)</td><td></td></tr>" -path $filePath write-host "Info: Found $($siteCollection.url)" -foregroundcolor green #search for webs $AllWebs = Get-SPOWebs($siteCollection.url) } } function Get-SPOWebs($url){ #fill metadata information to the client context variable $context = New-Object Microsoft.SharePoint.Client.ClientContext($url) $context.Credentials = $SPOcredentials $web = $context.Web $context.Load($web) $context.Load($web.Webs) $context.load($web.lists) try{ $context.ExecuteQuery() #loop through all lists in the web foreach($list in $web.lists){ add-content -value "<tr><td><span style='margin-left:$($pixelslist)px'>$($list.title)</td><td>List/library</td><td></td><td>$($list.itemcount)</td></tr>" -path $filePath } #loop through all webs in the web and start again to find more subwebs $pixelsweb = $pixelsweb + 15 $pixelslist = $pixelslist + 15 foreach($web in $web.Webs) { add-content -value "<tr style='background-color:yellow'><td><span style='margin-left:$($pixelsweb)px'>$($web.url)</td><td>Web</td><td>$($web.webtemplate)</td><td></td></tr>" -path $filePath write-host "Info: Found $($web.url)" -foregroundcolor green Get-SPOWebs($web.url) } } catch{ write-host "Could not find web" -foregroundcolor red } } connectToO365 |
Save the code to a .ps1 file e.g. “O365InfoScript.ps1” Open the Read more about Get information of sites from SharePoint Online via Powershell[…]
The below code will will tell you how to Get the entire Site Structure in SharePoint Online using SharePoint Online Management Shell Get all Sub Sites from Site Collection (Title and URL) Get All Lists from a Site (Title and Item Count) This is a working code for Office 365 Do make sure you install Read more about Get the entire Site Structure in SharePoint Online using Powershell[…]
Few months ago I received a requirement for SharePoint 2007 where the SharePoint Site used custom fields through a third party solution. For e.g “Single Line of Text with Regex” So basically you create a column of this field type which I found it to be cool. But as this was a custom solution, we Read more about Get the list of Fields from the entire Site Collection using Powershell[…]