PowerShell to Search SharePoint and Export Results to CSV using Keyword Query
Requirement: Search SharePoint site and export the search results to CSV file using PowerShell.
PowerShell to Export SharePoint Search Results to CSV:
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 = "http://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:http://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()