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: https://www.powershellgallery.com/packages/Office365.Connect/. 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: https://blogs.technet.microsoft.com/beyondsharepoint/2016/09/15/considerations-when-deploying-sharepoint-office365-hybrid-workloads-in-a-farm-utilizing-provider-hosted-add-ins-or-workflow-manager/ 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: https://gallery.technet.microsoft.com/Encrypting-your-text-based-d939876b. 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: http://technet.microsoft.com/en-us/library/hh272537.aspx 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[…]

Get all subsites of a subsite using PowerShell

Getting a list of all subsites of a particular site (not a site collection) was a little more work than I expected, so here is how I did it. Let’s say we have the following situation site structure: What if we want an overview of all sites under “Https://portal.sharepointrelated.com/Projects”? My first thought was to use Read more about Get all subsites of a subsite using PowerShell[…]

Remove users from User Information List (people picker) using PowerShell

This post will describe how you can remove users in bulk from the User Information List using a PowerShell script and a simple CSV file. In SharePoint 2010, the people picker retrieves data from multiple sources. – The Site Collection’s User Information List (UIL); – Active Directory. When you delete a user from Active Directory, Read more about Remove users from User Information List (people picker) using PowerShell[…]