Nagios Support Forum

This might help out anyone tring to monitor "SQL 2013 Always-On"..

Setup Nagios to call local command: sqlps -Command "&{C:\Scripts\AvailableGroupStatus.ps1}"

Replace "SERVERNAME" with your SQL ServerName
Replace "SQLINSTANCE" with your SQL InstanceName
Replace "AVAILGROUPNAME" with your SQL AvailableGroup Name to check
-------
AvailableGroupStatus.ps1
-------
cd SQLSERVER:\SQL\"SERVERNAME"\"SQLINSTANCE"\AvailabilityGroups
$Results = Test-SqlAvailabilityGroup "AVAILGROUPNAME" | Select HealthState
if($Results.HealthState -eq "Healthy"){
$Output = "OK: AvailabilityGroup Databases are Healthy"
}else{

$Output = $Results.HealthState + " - Error"
$statFlag = 1
}
Write-Host $Output

if($statFlag -eq 1){
exit 2
}else{
exit 0
}
exit

If you have any questions.. Just YELL..

Thank you for the contribution jhagedorn!

It is not FULLY documented.. But if you have setup remote powershell scripts, it should be ok.. There are other PSSQL commands.. http://technet.microsoft.com/en-us/libr ... 78391.aspx

HAHA M$ fully documenting things? Nice script though!!

Im going to modify this to pass 3 parameters HostName/Instance/AvailabityGroup... Ill update it, when I get it working.. LOL Unless someone was to do my task..

Have at it man! Params at the beginning of the script should handle most of that looking at your current code.