Export SharePoint 2013 Search Crawl History to CSV using PowerShell

Requirement: Extract crawl history of SharePoint 2013 search service application to a CSV file.

sharepoint 2013 export search crawl history to csv

PowerShell to Extract Last 10 Crawl Log History to CSV file:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Configuration Parameters
$ContentSourceName = "Local SharePoint sites"
$ResultsCount = 10

#Get Search Service application and Content Source
$SearchServiceApplication = Get-SPEnterpriseSearchServiceApplication
$ContentSource = Get-SPEnterpriseSearchCrawlContentSource -SearchApplication $searchServiceApplication | ? { $_.Name -eq $contentSourceName }

#Get Crawl History
$CrawlLog = new-object Microsoft.Office.Server.Search.Administration.CrawlLog($searchServiceApplication)
$CrawlHistory = $CrawlLog.GetCrawlHistory($ResultsCount, $ContentSource.Id)

#Export the Crawl History to CSV
$CrawlHistory | Export-CSV "C:\CrawlHistory.csv" -NoTypeInformation

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

Leave a Reply