SQL-DB Services-Unknown Status

ravishankar.gundlapali at wipro.com ravishankar.gundlapali at wipro.com
Thu Sep 23 12:45:42 CEST 2010


Hi All,

 

Request you to please help me on this.

 

 

Thanks,

Ravi G

 

From: Ravishankar Gundlapali (WT01 - Energy and Utilities) 
Sent: Tuesday, September 21, 2010 8:27 PM
To: 'Nagios Users List'
Subject: SQL-DB Services-Unknown Status

 

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.

 

The status information in Nagios is showing following error. Please see
the screenshots below

 1)      UNKNOWN: No handler for that command 

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.

 

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

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100923/1b7118b7/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3817 bytes
Desc: image001.png
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100923/1b7118b7/attachment.png>
-------------- next part --------------
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at 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


More information about the Users mailing list