<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <meta name=Generator content="Microsoft Word 12 (filtered medium)">  <style>  </style>  </head> <body lang=EN-US link=blue vlink=purple> <div class=Section1> Hi All,<o:p></o:p> <o:p> </o:p> Request you to provide any clue on this.<o:p></o:p> <o:p> </o:p> Thanks,<o:p></o:p> Ravi G<o:p></o:p> <o:p> </o:p> <div> <div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'> From: Ravishankar Gundlapali (WT01 - Energy and Utilities) Sent: Friday, September 10, 2010 9:43 PM To: Nagios Users List Cc: 'pangrazi@gmail.com' Subject: RE: [Nagios-users] SQL-DB Services-Unknown Status<o:p></o:p> </div> </div> <o:p> </o:p> When I ran the command ./check_nrpe -t 60 -H <Hostname> -p 5666 get_mssql_log_used<o:p></o:p> <o:p> </o:p> I got the below output….<o:p></o:p> I (0.3.5.1 2008-09-24) seem to be doing fine...<o:p></o:p> <o:p> </o:p> Please provide any clue…<o:p></o:p> <o:p> </o:p> Regards,<o:p></o:p> Ravi G<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'> From: Greg Pangrazio [mailto:pangrazi@gmail.com] Sent: Friday, September 10, 2010 8:22 PM To: Nagios Users List Subject: Re: [Nagios-users] SQL-DB Services-Unknown Status<o:p></o:p> </div> <o:p> </o:p> what does the NRPE config look like on the remote end? Are you allowed to run commands? What result do you get if you run check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_used -a $HOSTADDRESS$ with the proper variables from the command line on your nagios server? Greg Pangrazio <o:p></o:p> <div> On Fri, Sep 10, 2010 at 8:49 AM, <<a href="mailto:ravishankar.gundlapali@wipro.com">ravishankar.gundlapali@wipro.com</a>> wrote:<o:p></o:p> <div> <div> Hi,<o:p></o:p> <o:p></o:p> Please see the service definition and command definition which I am using for SQL-DB-LOG-USED and SQL-DB-LOG-GROWTH.<o:p></o:p> <o:p></o:p> Request you to provide a clue on this.<o:p></o:p> <o:p></o:p> <o:p></o:p> define service{<o:p></o:p> use generic-service ; Name of service template to use<o:p></o:p> host_name abcd<o:p></o:p> service_description SQL-DB-LOG-USED<o:p></o:p> is_volatile 0<o:p></o:p> check_period 24x7<o:p></o:p> max_check_attempts 3<o:p></o:p> normal_check_interval 5<o:p></o:p> retry_check_interval 1<o:p></o:p> contact_groups sql-admins<o:p></o:p> notification_interval 0<o:p></o:p> notification_period 24x7<o:p></o:p> notification_options c,r<o:p></o:p> check_command check_nrpe_mssql_log_used!*!50!90<o:p></o:p> }<o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p> define service{<o:p></o:p> use generic-service ; Name of service template to use<o:p></o:p> host_name abcd<o:p></o:p> service_description SQL-DB-LOG-GROWTH<o:p></o:p> is_volatile 0<o:p></o:p> check_period 24x7<o:p></o:p> max_check_attempts 3<o:p></o:p> normal_check_interval 5<o:p></o:p> retry_check_interval 1<o:p></o:p> contact_groups sql-admins<o:p></o:p> notification_interval 0<o:p></o:p> notification_period 24x7<o:p></o:p> notification_options c,r<o:p></o:p> check_command check_nrpe_mssql_log_growths!*!5000!9000 ; Log growth scale is 0.01 hence 5000 and 9000<o:p></o:p> }<o:p></o:p> <o:p></o:p> <o:p></o:p> define command {<o:p></o:p> command_name check_nrpe_mssql_log_used<o:p></o:p> command_line $USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_used -a $HOSTADDRESS$ "$ARG1$" "$ARG2$" "$ARG3$"<o:p></o:p> }<o:p></o:p> <o:p></o:p> <o:p></o:p> define command {<o:p></o:p> command_name check_nrpe_mssql_log_growths<o:p></o:p> command_line $USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_growth -a $HOSTADDRESS$ "$ARG1$" "$ARG2$" "$ARG3$"<o:p></o:p> }<o:p></o:p> <o:p></o:p> Thanks,<o:p></o:p> Ravi G<o:p></o:p> <div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in; border-color:-moz-use-text-color -moz-use-text-color'> From: Greg Pangrazio [mailto:<a href="mailto:pangrazi@gmail.com" target="_blank">pangrazi@gmail.com</a>] Sent: Friday, September 10, 2010 6:40 PM To: Nagios Users List Subject: Re: [Nagios-users] SQL-DB Services-Unknown Status<o:p></o:p> </div> <div> <div> <o:p></o:p> before anyone can help you we need the parts of the config that are important here. Can you give us the command definition, service definition and any other relevant part of the config?<o:p></o:p> <div> On Fri, Sep 10, 2010 at 2:28 AM, <<a href="mailto:ravishankar.gundlapali@wipro.com" target="_blank">ravishankar.gundlapali@wipro.com</a>> wrote:<o:p></o:p> <div> <div> Hi All,<o:p></o:p> <o:p></o:p> Request you to help me on this.<o:p></o:p> <o:p></o:p> Thanks,<o:p></o:p> Ravi G<o:p></o:p> <o:p></o:p> <div> <div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in; border-color:-moz-use-text-color'> From: Ravishankar Gundlapali (WT01 - Energy and Utilities) Sent: Thursday, September 09, 2010 3:42 PM To: 'Nagios Users List' Subject: SQL-DB Services-Unknown Status<o:p></o:p> </div> </div> <div> <div> <o:p></o:p> Hi,<o:p></o:p> <o:p></o:p> I am using Nagios Version 3.0.6 on a Linux server to monitor the SQL-DB-LOG-GROWTH and SQL-DB-LOG-USED on the Windows servers.<o:p></o:p> <o:p></o:p> For the many of the servers the status information is showing following errors. Please see the screenshots below<o:p></o:p> <o:p></o:p> 1) UNKNOWN: No handler for that command <o:p></o:p> 2) Unknown - * query: No row returned. <o:p></o:p> 3) CHECK_NRPE: Received 0 bytes from daemon. Check the remote server logs for error messages.<o:p></o:p> 4) Unknown - No data received from WMI: <o:p></o:p> <o:p></o:p> I am using the following the check commands <o:p></o:p> <o:p></o:p> check_nrpe_mssql_log_used!*!50!90<o:p></o:p> check_nrpe_mssql_log_growths!*!5000!9000<o:p></o:p> <o:p></o:p> Please someone let me know how can I resolve this. <o:p></o:p> <o:p></o:p> <img border=0 width=672 height=64 id="_x0000_i1025" src="cid:image001.png@01CB5353.2F4D57E0"><o:p></o:p> <img border=0 width=671 height=62 id="_x0000_i1026" src="cid:image002.png@01CB5353.2F4D57E0"><o:p></o:p> <img border=0 width=674 height=127 id="_x0000_i1027" src="cid:image003.png@01CB5353.2F4D57E0"><o:p></o:p> <img border=0 width=654 height=67 id="_x0000_i1028" src="cid:image004.png@01CB5353.2F4D57E0"><o:p></o:p> <o:p></o:p> Thanks & Regards,<o:p></o:p> Ravi G<o:p></o:p> <o:p></o:p> <o:p></o:p> </div> </div> </div> </div> ------------------------------------------------------------------------------ Automate Storage Tiering Simply Optimize IT performance and efficiency through flexible, powerful, automated storage tiering capabilities. View this brief to learn how you can reduce costs and improve performance. <a href="http://p.sf.net/sfu/dell-sfdev2dev" target="_blank">http://p.sf.net/sfu/dell-sfdev2dev</a> _______________________________________________ Nagios-users mailing list <a href="mailto:Nagios-users@lists.sourceforge.net" target="_blank">Nagios-users@lists.sourceforge.net</a> <a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null<o:p></o:p> </div> <o:p></o:p> </div> </div> </div> </div> ------------------------------------------------------------------------------ Automate Storage Tiering Simply Optimize IT performance and efficiency through flexible, powerful, automated storage tiering capabilities. View this brief to learn how you can reduce costs and improve performance. <a href="http://p.sf.net/sfu/dell-sfdev2dev" target="_blank">http://p.sf.net/sfu/dell-sfdev2dev</a> _______________________________________________ Nagios-users mailing list <a href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null<o:p></o:p> </div> <o:p> </o:p> </div> </body> </html>