Advertisement

Responsive Advertisement

SharePoint Online Search query to retrieve indexed site collections using PNP Powershell cmdlets

SharePoint Patterns and Practices (PnP) contains a library of PowerShell commands (PnP PowerShell) that allows you to perform complex provisioning and artifact management actions towards SharePoint. The commands use CSOM and can work against both SharePoint Online as SharePoint On-Premises.

The Office 365 Developer Patterns and Practices PowerShell Cmdlets turn out to be lifesavers for many Developers. This will  allow you to create artifacts in your SharePoint sites, like lists, fields, etc. without needing to click around or write a complex C# application.

The PowerShell Cmdlets come in 2 versions
  • Office 365
  • On-prem
To run these scripts, you need to install the SharePoint Online Management Shell and PnP PowerShell modules if you have not yet done .For PowerShell 5.0 or newer, run this command 

Install-Module Microsoft.Online.SharePoint.PowerShell

For older versions, download and run the SharePoint Online Management Shell installation package. After that, run this command in PowerShell as administrator: 

Import-Module Microsoft.Online.SharePoint.PowerShell -DisableNameChecking

To install PnP PowerShell, run this command as administrator: 

Install-Module SharePointPnPPowerShellOnline -AllowClobber
It’s good to update both of the modules regularly to get the latest changes and possible new command-lets.If you want to run the scripts by executing .ps1 files, you also need to run this command as administrator: 

Set-ExecutionPolicy Unrestricted

And a quick note in case you are using multi factor authentication (MFA): you need to change the authentication in the scripts slightly.

  • In the Connect-SPOService command-let, remove the -Credential parameter and its value. Doing so brings up the web login instead, which will prompt you for the authentication code.
  • For Connect-PnPOnline, omit the -Credentials parameter and its value, and replace it with -UseWebLogin.

To use the library you first need to connect to your tenant:







Connect-PnPOnline –Url https://yoursite.sharepoint.com –Credentials (Get-Credential)
#Run this below powershelgl script in your SharePoint online management shell.
#It applies to SharePoint Server 2013, SharePoint Server 2016, SharePoint Online.
#This below app will help you to understand how to Executes a search query to retrieve indexed site collections using PNP Powershell cmdlets
#The below script will returns the top 500 site collections indexed by SharePoint Search.
Get-PnPSiteSearchQueryResults -All
#Returns the top 500 site collections indexed by SharePoint Search which have are based on the STS (Team Site) template
Get-PnPSiteSearchQueryResults -Query “WebTemplate:STS”
#The below script will returns the top 10 site collections indexed by SharePoint Search.
Get-PnPSiteSearchQueryResults -MaxResults 10

Post a Comment

2 Comments

  1. This comment has been removed by the author.

    ReplyDelete
  2. Your blog is really good. This information is really useful for those who have searched for this and you have great knowledge about this. I’m really impressed with your post.Mexico Import Data

    ReplyDelete