SQL-DB Services-Unknown Status
ravishankar.gundlapali at wipro.com
ravishankar.gundlapali at wipro.com
Tue Nov 2 15:50:09 CET 2010
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20101102/d9b603c7/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/20101102/d9b603c7/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 3787 bytes
Desc: image002.png
URL: <https://www.monitoring-lists.org/archive/users/attachments/20101102/d9b603c7/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 3787 bytes
Desc: image003.png
URL: <https://www.monitoring-lists.org/archive/users/attachments/20101102/d9b603c7/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
More information about the Users
mailing list