<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.2800.1498" name=GENERATOR> <STYLE>@font-face { font-family: Tahoma; } @page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; } font-face { FONT-FAMILY: Tahoma } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline } A:visited { COLOR: purple; TEXT-DECORATION: underline } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline } PRE { FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Courier New" } SPAN.emailstyle17 { COLOR: windowtext; FONT-FAMILY: Arial } SPAN.EmailStyle19 { COLOR: navy; FONT-FAMILY: Arial } DIV.Section1 { page: Section1 } </STYLE> </HEAD> <BODY lang=EN-US vLink=purple link=blue> <DIV dir=ltr align=left>Hi all,</DIV> <DIV dir=ltr align=left> </DIV> <DIV dir=ltr align=left>In the contrib folder there's a check_mssql plug-in.</DIV> <DIV dir=ltr align=left>u can tweak it to do whatever you want it to do.</DIV> <DIV dir=ltr align=left> </DIV> <DIV dir=ltr align=left>I'm working on changing it so it can check free space left in the MsSQL database</DIV> <DIV dir=ltr align=left> </DIV> <DIV dir=ltr align=left>A.</DIV> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> From: nagios-users-admin@lists.sourceforge.net [mailto:nagios-users-admin@lists.sourceforge.net] On Behalf Of Petrucci, Joseph Sent: Wednesday, October 12, 2005 10:36 AM To: Forough, Hamid; nagios-users@lists.sourceforge.net Subject: RE: [Nagios-users] PLease help </DIV> <DIV></DIV> <DIV>There is a SQL function called raiseerror it will write an error that you definewithin the SQL server to the errorlog. This is in Sybase but I thionk it is still in MSSQL. you can find information on it in the admin manual. I use this functio inside my stored procedures to put the results of the procedure in the errorlog. I then use a passive check in Nagios to read the errorlog (I wrote this in ActivePerl) and look for certain error codes. The passive plugin passes the results to Nagios every 5 minutes and Nagios sends a critical alert if any of the errors are present in the errorlog for the given period.</DIV> <BLOCKQUOTE dir=ltr style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: Forough, Hamid [mailto:hamid.forough@amd.com] Sent: Wednesday, October 12, 2005 10:18 AM To: Petrucci, Joseph; nagios-users@lists.sourceforge.net Subject: RE: [Nagios-users] PLease help </DIV> <DIV class=Section1> I don’t understand. Can you elaborate please? <DIV> <DIV class=MsoNormal style="TEXT-ALIGN: center" align=center> <HR tabIndex=-1 align=center width="100%" SIZE=2> </DIV> From: Petrucci, Joseph [mailto:Joseph.Petrucci@ddiworld.com] Sent: Tuesday, October 11, 2005 11:58 AM To: Forough, Hamid; nagios-users@lists.sourceforge.net Subject: RE: [Nagios-users] PLease help</DIV> <DIV id=idOWAReplyText43136> <DIV> I do this with Sybase and it should still work this way i MSSQL 2K.</DIV> <DIV> </DIV> <DIV> 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) </DIV> <DIV> </DIV></DIV> <DIV id=idSignature21269><PRE>Joseph A. Petrucci</PRE><PRE>E Systems DBA</PRE><PRE>------------------------------------------------</PRE><PRE>Desk: 412-220-2646</PRE><PRE>Cell: 412-916-2867</PRE><PRE>Text message (e-mail) 4129162867@mobile.att.net</PRE><PRE>e-mail joseph.petrucci@ddiworld.com</PRE><PRE>Personal Cell: 724-462-0443</PRE><PRE>Personal e-mail: japetrucci@hotmail.com</PRE></DIV> <DIV> <DIV class=MsoNormal style="TEXT-ALIGN: center" align=center> <HR tabIndex=-1 align=center width="100%" SIZE=2> </DIV> From: nagios-users-admin@lists.sourceforge.net on behalf of Forough, Hamid Sent: Tue 10/11/2005 11:45 AM To: nagios-users@lists.sourceforge.net Subject: [Nagios-users] PLease help</DIV> <DIV> 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 Thanks, Hamid Advanced Micro Devices <IMG height=29 src="cid:999495317@12102005-0F59" width=108 border=0> W: 512.602.4704 C: 512.971-5345 E: <A href="mailto:hamid.forough@amd.com">hamid.forough@amd.com</A> </DIV></DIV></BLOCKQUOTE></BODY></HTML>