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:[email protected]] 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, <[email protected]> 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 [email protected] 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 [email protected] 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
<<image001.png>>
<<image002.png>>
<<image003.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 [email protected] 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
