PowerShell to Search SharePoint and Export Results to CSV using Keyword Query
Requirement: Search a SharePoint site and export the search results to CSV file using PowerShell
PowerShell to Export SharePoint Search Results to CSV
In this blog post, we will show you how to use PowerShell to search for information in SharePoint and then export the search results to a CSV file. This makes it easy to analyze and report on the data that you find.
Here is the PowerShell to search all documents in a SharePoint Online site collection and export search results to CSV:
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
#Set Parameters
$SiteURL = "https://intranet.crescent.com/"
$CSVFile = "C:\Temp\SearchResults.csv"
#Get the site collection
$Site = Get-SPSite $SiteURL
#Frame Query to search: Get all documents sorted by Last modified
$keywordQuery = New-Object Microsoft.Office.Server.Search.Query.KeywordQuery($Site)
$SearchQuery = "site:https://intranet.crescent.com ContentType:document NOT FileExtension:aspx"
$keywordQuery.QueryText = $SearchQuery
$keywordQuery.SortList.Add("LastModifiedTime","Asc")
#Execute Search
$SearchExecutor = New-Object Microsoft.Office.Server.Search.Query.SearchExecutor
$searchResults = $SearchExecutor.ExecuteQuery($keywordQuery)
#Get Search Results
$Table = $SearchResults.Table
$Table | select Title, Path, Author, LastModifiedTime
#Export Search results to Excel
$Table | Export-Csv $CSVFile -NoTypeInformation
Write-Host -f Green "Search Results Exported to CSV File!"
And the result CSV:
Here is how to search SharePoint Online using Keyword query: PowerShell to Search SharePoint Online Site using Keyword Query
Yes I am getting the same, just 50 results each time.
The default RowLimit on Keyword query is 50! You can set the Row limit to something like “$KeyWordQuery.RowLimit = 500”
I have more than 14000 records return with a search word but I only am getting approx 50 records in CSV
Besides setting the KeywordQuery.Rowlimit, You may have to also set the search service application’s Row limit:
$SSA= Get-SPEnterpriseSearchServiceApplication
$SSA.MaxRowLimit = 10000
$SSA.Update()