powershell | Rey Rahadian

What i want to do is to build an app that send out an email every time there’s a failed crawl operation when we trigger the crawling operation against a service service application. After reading about it, it seems there are no configuration in the Microsoft Search Server that provide this out of the box.

Instead i found out that you could use the PowerShell to perform administrative task. From getting the search service application of a farm, add it, delete it, and other kind of tasks, read more about the cmdlets available in the documentation.

With this knowledge I’m set to build is a simple script to get the current error message from today’s crawl operation and then send the results through an email. This script will be triggered daily by a task scheduler.

I have no experience on coding on PowerShell before and luckily i found some existing script that i can just tweak a bit to do just what i want.

The PowerShell script that I’ve tweaked.

$ver = $host | select version 
if ($ver.Version.Major -gt 1) {
	$Host.Runspace.ThreadOptions = "ReuseThread"
} 
if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) { 
	Add-PsSnapin Microsoft.SharePoint.PowerShell 
} 

#----CONFIGS 
$searchServiceName = "just testing" 
$logFilePath = "c:tempsearchserverlog.txt" 

function GetErrorLogs(){ 
	$ssa = Get-SPEnterpriseSearchServiceApplication | Where-Object {$_.Name -eq $searchServiceName} 
	$ssaContent = new-object Microsoft.Office.Server.Search.Administration.Content($ssa) 
	$logViewer = New-Object Microsoft.Office.Server.Search.Administration.Logviewer $ssa 
	$ErrorList = $logViewer.GetAllStatusMessages() | Select ErrorId 
	$crawlLogFilters = New-Object Microsoft.Office.Server.Search.Administration.CrawlLogFilters; 
	$crawlLogFilters.AddFilter([Microsoft.Office.Server.Search.Administration.MessageType]"Error"); 
	$startNum = 0; 
	$errorItems += $logViewer.GetCurrentCrawlLogData($crawlLogFilters, ([ref] $startNum)); 

	WHILE($startNum -ne -1){ 
		$crawlLogFilters.AddFilter("StartAt", $startNum); 
		$startNum = 0; 
		$errorItems += $logViewer.GetCurrentCrawlLogData($crawlLogFilters, ([ref] $startNum)); 
	} 

	return $errorItems 
} 

function sendEmail($errorItemsParam){ 
	$currentDate = get-date; 
	$isThereAnyErrorsToday = "false"; 
	$result = "<table>"; 

	foreach($error in $errorItemsParam){ 
		$date = get-date $error.LastTouchStart; 
		if($date.Date -eq $currentDate.Date){ 
			$result += "<tr><td>DisplayUrl</td><td>"+$error.DisplayUrl+"</td></tr>"; 
			$result += "<tr><td>ErrorLevel</td><td>"+$error.ErrorLevel+"</td></tr>"; 
			$result += "<tr><td>ErrorMsg</td><td>"+$error.ErrorMsg+"</td></tr>"; 
			$result += "<tr><td>HResult</td><td>"+$error.HResult+"</td></tr>"; 
			$result += "<tr><td>ErrorDesc</td><td>"+$error.ErrorDesc+"</td></tr>"; 
			$result += "<tr><td>ContentSourceId</td><td>"+$error.ContentSourceId+"</td></tr>"; 
			$result += "<tr><td>LastTouchStart</td><td>"+$error.LastTouchStart+"</td></tr>"; 
			$result += "<tr><td colspan='2'></td></tr>"; 
			$result += "<tr><td colspan='2'></td></tr>"; $isThereAnyErrorsToday = "true"; 
		} 
	} 

	$result += "</table>";      

	#Write-Host $result 
	$result > $logFilePath #SMTP server name $smtpServer = "mailserver.com" 
	
	#Creating a Mail object 
	$msg = new-object Net.Mail.MailMessage 

	#Email structure 
	$msg.From = "powershellscript@xxxx.com" 
	$msg.ReplyTo = "powershellscript@xxxx.com" 
	$msg.To.Add("recipient@xxxx.com") 
	$msg.Subject = "Search server error logs" 
	$msg.Body = Get-Content $logFilePath 
	$msg.IsBodyHtml = "true"; 

	#Creating SMTP server object $smtp = new-object Net.Mail.SmtpClient($smtpServer) 

	#Sending email 
	if($isThereAnyErrorsToday -eq "true"){ 
		Write-Host "Sending Email" 
		$smtp.Send($msg) 
	} 
	else{ 
		Write-Host "No error today" 
	} 
} 

$messageBody = GetErrorLogs sendEmail($messageBody)

$ver = $host | select version

if ($ver.Version.Major -gt 1) {

$Host.Runspace.ThreadOptions = "ReuseThread"

}

if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) {

Add-PsSnapin Microsoft.SharePoint.PowerShell

}

#----CONFIGS

$searchServiceName = "just testing"

$logFilePath = "c:tempsearchserverlog.txt"

function GetErrorLogs(){

$ssa = Get-SPEnterpriseSearchServiceApplication | Where-Object {$_.Name -eq $searchServiceName}

$ssaContent = new-object Microsoft.Office.Server.Search.Administration.Content($ssa)

$logViewer = New-Object Microsoft.Office.Server.Search.Administration.Logviewer $ssa

$ErrorList = $logViewer.GetAllStatusMessages() | Select ErrorId

$crawlLogFilters = New-Object Microsoft.Office.Server.Search.Administration.CrawlLogFilters;

$crawlLogFilters.AddFilter([Microsoft.Office.Server.Search.Administration.MessageType]"Error");

$startNum = 0;

$errorItems += $logViewer.GetCurrentCrawlLogData($crawlLogFilters, ([ref] $startNum));

WHILE($startNum -ne -1){

$crawlLogFilters.AddFilter("StartAt", $startNum);

$startNum = 0;

$errorItems += $logViewer.GetCurrentCrawlLogData($crawlLogFilters, ([ref] $startNum));

}

return $errorItems

}

function sendEmail($errorItemsParam){

$currentDate = get-date;

$isThereAnyErrorsToday = "false";

$result = "<table>";

foreach($error in $errorItemsParam){

$date = get-date $error.LastTouchStart;

if($date.Date -eq $currentDate.Date){

$result += "<tr><td>DisplayUrl</td><td>"+$error.DisplayUrl+"</td></tr>";

$result += "<tr><td>ErrorLevel</td><td>"+$error.ErrorLevel+"</td></tr>";

$result += "<tr><td>ErrorMsg</td><td>"+$error.ErrorMsg+"</td></tr>";

$result += "<tr><td>HResult</td><td>"+$error.HResult+"</td></tr>";

$result += "<tr><td>ErrorDesc</td><td>"+$error.ErrorDesc+"</td></tr>";

$result += "<tr><td>ContentSourceId</td><td>"+$error.ContentSourceId+"</td></tr>";

$result += "<tr><td>LastTouchStart</td><td>"+$error.LastTouchStart+"</td></tr>";

$result += "<tr><td colspan='2'></td></tr>";

$result += "<tr><td colspan='2'></td></tr>"; $isThereAnyErrorsToday = "true";

}

$result += "</table>";

#Write-Host $result

$result > $logFilePath #SMTP server name $smtpServer = "mailserver.com"

#Creating a Mail object

$msg = new-object Net.Mail.MailMessage

#Email structure

$msg.From = "[email protected]"

$msg.ReplyTo = "[email protected]"

$msg.To.Add("[email protected]")

$msg.Subject = "Search server error logs"

$msg.Body = Get-Content $logFilePath

$msg.IsBodyHtml = "true";

#Creating SMTP server object $smtp = new-object Net.Mail.SmtpClient($smtpServer)

#Sending email

if($isThereAnyErrorsToday -eq "true"){

Write-Host "Sending Email"

$smtp.Send($msg)

}

else{

Write-Host "No error today"

}

$messageBody = GetErrorLogs sendEmail($messageBody)

This script will be executed by a batch script which in turn is setup to run every day by a Task Scheduler.

powershell -noexit "& "D:\search-error-in-logs.ps1"

1	powershell -noexit "& "D:\search-error-in-logs.ps1"

The end result would be like this

DisplayUrl http://kompasabc.com 
ErrorLevel 2 
ErrorMsg The URL of the item could not be resolved. The repository might be unavailable, or the crawler proxy settings are not configured. To configure the crawler proxy settings, use Search Administration page. 
HResult -2147216863 
ErrorDesc 
ContentSourceId 3 
LastTouchStart 03/22/2013 00:24:01 

DisplayUrl http://ljkadjalsdkjalskdlaskjdlajd.com 
ErrorLevel 2 
ErrorMsg The URL of the item could not be resolved. The repository might be unavailable, or the crawler proxy settings are not configured. To configure the crawler proxy settings, use Search Administration page. 
HResult -2147216863 
ErrorDesc 
ContentSourceId 3 
LastTouchStart 03/22/2013 00:23:53 

DisplayUrl http://kompas123.com 
ErrorLevel 2 
ErrorMsg The URL of the item could not be resolved. The repository might be unavailable, or the crawler proxy settings are not configured. To configure the crawler proxy settings, use Search Administration page.
HResult -2147216863 
ErrorDesc 
ContentSourceId 3 
LastTouchStart 03/22/2013 00:23:53 

DisplayUrl http://yayayayayayayayaya.com 
ErrorLevel 2 
ErrorMsg The URL of the item could not be resolved. The repository might be unavailable, or the crawler proxy settings are not configured. To configure the crawler proxy settings, use Search Administration page. 
HResult -2147216863 
ErrorDesc 
ContentSourceId 3 
LastTouchStart 03/22/2013 00:23:53 

DisplayUrl http://kompasabc123.com 
ErrorLevel 2 
ErrorMsg The URL of the item could not be resolved. The repository might be unavailable, or the crawler proxy settings are not configured. To configure the crawler proxy settings, use Search Administration page. 
HResult -2147216863 
ErrorDesc 
ContentSourceId 3 
LastTouchStart 03/22/2013 00:23:51

DisplayUrl http://kompasabc.com

ErrorLevel 2

ErrorMsg The URL of the item could not be resolved. The repository might be unavailable, or the crawler proxy settings are not configured. To configure the crawler proxy settings, use Search Administration page.

HResult -2147216863

ErrorDesc

ContentSourceId 3

LastTouchStart 03/22/2013 00:24:01

DisplayUrl http://ljkadjalsdkjalskdlaskjdlajd.com

ErrorLevel 2

HResult -2147216863

ErrorDesc

ContentSourceId 3

LastTouchStart 03/22/2013 00:23:53

DisplayUrl http://kompas123.com

ErrorLevel 2

HResult -2147216863

ErrorDesc

ContentSourceId 3

LastTouchStart 03/22/2013 00:23:53

DisplayUrl http://yayayayayayayayaya.com

ErrorLevel 2

HResult -2147216863

ErrorDesc

ContentSourceId 3

LastTouchStart 03/22/2013 00:23:53

DisplayUrl http://kompasabc123.com

ErrorLevel 2

HResult -2147216863

ErrorDesc

ContentSourceId 3

LastTouchStart 03/22/2013 00:23:51

Rey Rahadian

continuous improvement ftw

Tag Archives: powershell

Using powershell to install Sitecore from a zip file until we get a running website

Like this:

Sending out Microsoft Search Server failed crawl messages

Like this:

Share this:

Like this:

Share this:

Like this: