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
On Tue, Nov 2, 2010 at 9:50 AM, <ravishankar.gundlap...@wipro.com> wrote: > 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 > > > > *From:* Greg Pangrazio [mailto:pangr...@gmail.com] > *Sent:* Tuesday, November 02, 2010 8:07 PM > *To:* Nagios Users List > *Subject:* Re: [Nagios-users] SQL-DB Services-Unknown Status > > > > 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 > > > On Tue, Nov 2, 2010 at 9:13 AM, <ravishankar.gundlap...@wipro.com> wrote: > > 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. > > > > 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* > > > > > > > > ------------------------------------------------------------------------------ > 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. > http://p.sf.net/sfu/dell-sfdev2dev > _______________________________________________ > Nagios-users mailing list > Nagios-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/nagios-users > ::: Please include Nagios version, plugin version (-v) and OS when > reporting any issue. > ::: Messages without supporting info will risk being sent to /dev/null > > > > > > ------------------------------------------------------------------------------ > 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 > http://p.sf.net/sfu/nokia-dev2dev > _______________________________________________ > Nagios-users mailing list > Nagios-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/nagios-users > ::: Please include Nagios version, plugin version (-v) and OS when > reporting any issue. > ::: Messages without supporting info will risk being sent to /dev/null > > > > * 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. > > www.wipro.com >
<<image001.png>>
<<image003.png>>
<<image002.png>>
------------------------------------------------------------------------------ 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 http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null