Did you write get_mssql_log_used? It does not seem to be returning according to the standard nagios requirements. see <a href="http://nagiosplug.sourceforge.net/developer-guidelines.html">http://nagiosplug.sourceforge.net/developer-guidelines.html</a> Greg Pangrazio <div class="gmail_quote">On Mon, Sep 13, 2010 at 4:21 AM, <<a href="mailto:ravishankar.gundlapali@wipro.com">ravishankar.gundlapali@wipro.com</a>> wrote: <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> <div link="blue" vlink="purple" lang="EN-US"> <div> Hi All, Request you to provide any clue on this. Thanks, Ravi G <div> <div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0in 0in;"> From: Ravishankar Gundlapali (WT01 - Energy and Utilities) Sent: Friday, September 10, 2010 9:43 PM To: Nagios Users List Cc: '<a href="mailto:pangrazi@gmail.com" target="_blank">pangrazi@gmail.com</a>' Subject: RE: [Nagios-users] SQL-DB Services-Unknown Status </div> </div><div class="im"> When I ran the command ./check_nrpe -t 60 -H <Hostname> -p 5666 get_mssql_log_used I got the below output…. I (0.3.5.1 2008-09-24) seem to be doing fine... Please provide any clue… Regards, </div>Ravi G <div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0in 0in;"> From: Greg Pangrazio [mailto:<a href="mailto:pangrazi@gmail.com" target="_blank">pangrazi@gmail.com</a>] Sent: Friday, September 10, 2010 8:22 PM<div><div></div><div class="h5"> To: Nagios Users List Subject: Re: [Nagios-users] SQL-DB Services-Unknown Status</div></div> </div><div><div></div><div class="h5"> 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 <div> On Fri, Sep 10, 2010 at 8:49 AM, <<a href="mailto:ravishankar.gundlapali@wipro.com" target="_blank">ravishankar.gundlapali@wipro.com</a>> wrote: <div> <div> Hi, Please see the service definition and command definition which I am using for SQL-DB-LOG-USED and SQL-DB-LOG-GROWTH. Request you to provide a clue on this. define service{ use generic-service ; Name of service template to use host_name abcd service_description SQL-DB-LOG-USED is_volatile 0 check_period 24x7 max_check_attempts 3 normal_check_interval 5 retry_check_interval 1 contact_groups sql-admins notification_interval 0 notification_period 24x7 notification_options c,r check_command check_nrpe_mssql_log_used!*!50!90 } define service{ use generic-service ; Name of service template to use host_name abcd service_description SQL-DB-LOG-GROWTH is_volatile 0 check_period 24x7 max_check_attempts 3 normal_check_interval 5 retry_check_interval 1 contact_groups sql-admins notification_interval 0 notification_period 24x7 notification_options c,r check_command check_nrpe_mssql_log_growths!*!5000!9000 ; Log growth scale is 0.01 hence 5000 and 9000 } define command { command_name check_nrpe_mssql_log_used command_line $USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_used -a $HOSTADDRESS$ "$ARG1$" "$ARG2$" "$ARG3$" } define command { command_name check_nrpe_mssql_log_growths command_line $USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_growth -a $HOSTADDRESS$ "$ARG1$" "$ARG2$" "$ARG3$" } Thanks, Ravi G <div style="border-width: 1pt medium medium; border-style: solid none none; padding: 3pt 0in 0in; border-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 </div> <div> <div> 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? <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: <div> <div> Hi All, Request you to help me on this. Thanks, Ravi G <div> <div style="border-width: 1pt medium medium; border-style: solid none none; padding: 3pt 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 </div> </div> <div> <div> Hi, 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. For the many of the servers the status information is showing following errors. Please see the screenshots below 1) UNKNOWN: No handler for that command 2) Unknown - * query: No row returned. 3) CHECK_NRPE: Received 0 bytes from daemon. Check the remote server logs for error messages. 4) Unknown - No data received from WMI: I am using the following the check commands check_nrpe_mssql_log_used!*!50!90 check_nrpe_mssql_log_growths!*!5000!9000 Please someone let me know how can I resolve this. <img src="cid:image001.png@01CB5353.2F4D57E0" height="64" width="672" border="0"> <img src="cid:image002.png@01CB5353.2F4D57E0" height="62" width="671" border="0"> <img src="cid:image003.png@01CB5353.2F4D57E0" height="127" width="674" border="0"> <img src="cid:image004.png@01CB5353.2F4D57E0" height="67" width="654" border="0"> Thanks & Regards, Ravi G </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 </div> </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 </div> </div></div></div> Please do not print this email unless it is absolutely necessary. <div class="im"> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. <a href="http://www.wipro.com" target="_blank">www.wipro.com</a> </div></div> </blockquote></div>