We often get the question to list the site structure for SharePoint on premise and this can be done quite easily with get-spsite, get-spweb and get-splist but only get-sposite is available for SharePoint Online. This script will do the following:

– get all root sites in SharePoint Online and show its template

– get all webs and subwebs from root sites in SharePoint Online and show Its template

– get all lists from sites and webs in SharePoint Online and show its item count

– collect this information and store this in an HTML table

The script will generate the following output:


You will need to install the SharePoint Online Management Shell from https://www.microsoft.com/en-us/download/details.aspx?id=35588 and all of its pre-requisites. The below script needs to be copied to a .ps1 file on the workstation you are planning to run this script. It will create a logfile on the same location.

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


Connect-SPOService -Url $adminUrl -Credential $credentials

write-host "Info: Connected succesfully to Office 365" -foregroundcolor green



write-host "Error: Could not connect to Office 365" -foregroundcolor red

Break connectToO365


#create HTML file

$filePath = create-outputfile

#start getting site collections


add-content -value "



" -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 "



<h1>Sites information Office 365</h1>

<table border='1' style='font-family: Calibri, sans-serif'>


<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>


" -path $filePath



#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






#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





write-host "Could not find web" -foregroundcolor red






This script has been run on a workstation with Windows 8.1. First run the SharePoint Online Management Shell as administrator

SharePoint Online Management Shell logo.

Then run the following command

& “script location”


And answer the following three questions


And press enter


All sites have been successfully crawled and its contents is listed in the HTML document located next to the .ps1 file


You can list more information if you want and you can find the properties on the following locations:

– SPOSite properties: http://documents.software.dell.com/one-identity-quick-connect-for-cloud-services/3.6/administrator-guide/working-with-microsoft-office-365/microsoft-office-365-data-supported-out-of-the-box/sposite-object-attributes

– Web properties: https://msdn.microsoft.com/EN-US/library/office/microsoft.sharepoint.client.web_properties.aspx

– List properties: https://msdn.microsoft.com/EN-US/library/office/microsoft.sharepoint.client.list_properties.aspx

Let me know if you have any remarks or updates


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.