SQL-DB Services-Unknown Status

[Greg Pangrazio]

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.gundlapali at 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:pangrazi at 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.gundlapali at 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 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
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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 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
>
>
>
> * 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20101102/9d1dc936/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3817 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20101102/9d1dc936/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 3787 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20101102/9d1dc936/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 3787 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20101102/9d1dc936/attachment-0002.png>
-------------- next part --------------
------------------------------------------------------------------------------
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
-------------- 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