<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html>
<head>
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
font-face
{font-family:Tahoma;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<DIV id=idOWAReplyText43136 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>I do this with Sybase and it
should still work this way i MSSQL 2K.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>I would use a passive check
(info on this is in the manual) that reads the errorlog. Then you will
have to have your procedure execute a raiserror in the event of failure or any
other message you want. Have the plugin look at the error log for specific error
numbers that you define in the master.dbo.syserrors table (If there still is
one) </FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2></FONT> </DIV></DIV>
<DIV id=idSignature21269 dir=ltr><PRE>Joseph A. Petrucci
E Systems DBA
------------------------------------------------
Desk: 412-220-2646
Cell: 412-916-2867
Text message (e-mail) 4129162867@mobile.att.net
e-mail joseph.petrucci@ddiworld.com
Personal Cell: 724-462-0443
Personal e-mail: japetrucci@hotmail.com</PRE></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> nagios-users-admin@lists.sourceforge.net
on behalf of Forough, Hamid<BR><B>Sent:</B> Tue 10/11/2005 11:45
AM<BR><B>To:</B> nagios-users@lists.sourceforge.net<BR><B>Subject:</B>
[Nagios-users] PLease help<BR></FONT><BR></DIV>
<DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I need to know how to write a custom
plugin that checks results of a stored procedure in MSSQL 2k and returns Yes or
NO? I am using 2b4 verision of Nagios</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thanks,<BR>Hamid</SPAN></FONT></P>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Advanced Micro
Devices</SPAN></FONT></B></P>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><IMG height=29 src="image001.gif"
width=108 border=0></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN lang=DE
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">W: 512.602.4704<BR>C:
512.971-5345<BR>E: <A
href="mailto:hamid.forough@amd.com">hamid.forough@amd.com</A></SPAN></FONT><SPAN
lang=DE><BR> </SPAN></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN lang=DE
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></DIV>
</body>
</html>