Private channels

Finding Teams private channels

Just a quick note. If you are looking for all private channels created in Teams, you can use the following line of PowerShell: If you are just looking for the amount of private channels (to see if it is actively growing), use: I also wrote a PowerShell module to let you easily & securely connect Read more about Finding Teams private channels[…]

The mysterious case of Get-SPOSite

Background Sometimes you run into weird issues when you are doing the most common things. In this case, my colleague Marc Molenaar was cleaning up our demo Office 365 tenant. To make an overview of all site collections, he ran the following cmdlet: This would make a list of all site collections that are available in Read more about The mysterious case of Get-SPOSite[…]

SharePoint Online Management PowerShell module

Summary: This blog post describes why you do not need the SharePoint Online Management Shell anymore! If you worked with PowerShell for SharePoint Online in the last year, you had to download a new PowerShell console from: On the 31st of August 2018 Microsoft released a new* PowerShell module to the PowerShell gallery: Microsoft.Online.SharePoint.PowerShell. This Read more about SharePoint Online Management PowerShell module[…]

Office 365 Connect

PowerShell – Easy & secure connection to Office 365

Introduction Are you tired of remembering all those cmdlets to connect to Exchange Online, SharePoint Online. So many different cmdlets for the different services. With this PowerShell module you don’t need to remember anything (not even your password!) I published my first PowerShell module to the PowerShell Gallery: The module contains 2 cmdlets that you Read more about PowerShell – Easy & secure connection to Office 365[…]

Fixing apps after configuring SharePoint Hybrid

Update: Microsoft included the fix in the hybrid picker experience. This means you no longer have to perform the steps outlined in this blog post. You can find the updated article by Microsoft here: For hybrid search (outbound/inbound query federation or Cloud Hybrid Search Service Application) a manual approach is needed to remediate this Read more about Fixing apps after configuring SharePoint Hybrid[…]

People picker settings for all Web Applications one-liner

Summary: This PowerShell one-liner will show the people picker settings for each Web Application, including Central Administration. If you want to know the settings for the people picker in your SharePoint farm, you can run the following line of PowerShell. It will retrieve all Web Applications and show the people picker settings for each one. Running Read more about People picker settings for all Web Applications one-liner[…]

Download content from a site collection

I’ve been working on a script that will allow you to download all files that are stored in SharePoint in a given site collection. If the path does not exist, the script will prompt you to create it for you. Before the script runs, it also checks if the site collection exists. Run the script Read more about Download content from a site collection[…]

Encrypting text-based files using PowerShell

  This script will encrypt text-based files using PowerShell. Please find the script in the TechNet Gallery here. All updates to this script will also be managed here: As a SharePoint administrator I am often asked to script certain tasks. Of course, PowerShell does a great job at this, as it allows me to Read more about Encrypting text-based files using PowerShell[…]

Restore deleted site collections SharePoint 2013

In SharePoint 2013 it is possible to restore a deleted site collection. For more information, read this article: You can use the Restore-SPDeletedSite cmdlet to restore a site collection. However, if you removed the site collection using the Remove-SPSite cmdlet using PowerShell, the site collection will not be stored in a SPDeletedSite object. This Read more about Restore deleted site collections SharePoint 2013[…]