Go ask your Database admin for a query that will return a few rows. I can't write the query for you I have no idea what your SQL schemas are or how your database is configured. Greg Pangrazio <div class="gmail_quote">On Tue, Nov 2, 2010 at 9:50 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 , Please let me know which plugin I can use to resolve this issue. Also please let me know the query which I have to use. Thanks, 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: Tuesday, November 02, 2010 8:07 PM To: Nagios Users List Subject: Re: [Nagios-users] SQL-DB Services-Unknown Status </div><div><div></div><div class="h5"> I don't use this plugin, but it looks like it doesn't like the "*" between the first and second "!". That spot holds the sql query so try a real query that will return some rows like a select statement. Greg Pangrazio <div> On Tue, Nov 2, 2010 at 9:13 AM, <<a href="mailto:ravishankar.gundlapali@wipro.com" target="_blank">ravishankar.gundlapali@wipro.com</a>> wrote: <div> <div> <div> <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) 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@01CB7ACB.58F17500" height="64" width="672" border="0"> <img src="cid:image002.png@01CB7ACB.58F17500" height="62" width="671" border="0"> <img src="cid:image003.png@01CB7ACB.58F17500" height="67" width="654" border="0"> 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 & 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> ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store <a href="http://p.sf.net/sfu/nokia-dev2dev" target="_blank">http://p.sf.net/sfu/nokia-dev2dev</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. 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> </blockquote></div>