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.<br>
<br clear="all">Greg Pangrazio<br><br>
<br><br><div class="gmail_quote">On Tue, Nov 2, 2010 at 9:13 AM, <span dir="ltr"><<a href="mailto:ravishankar.gundlapali@wipro.com">ravishankar.gundlapali@wipro.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Hi,</p>
<p class="MsoNormal"> 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<span style="color: rgb(31, 73, 125);"> </span>Windows
servers<span style="color: rgb(31, 73, 125);">.</span></p>
<p class="MsoNormal">For
the many of the servers the status information is showing following errors.
Please see the screenshots below</p>
<p>1)<span style="font-size: 7pt;"> </span>UNKNOWN:
No handler for that command </p>
<p>2)<span style="font-size: 7pt;"> </span>Unknown
- * query: No row returned. </p>
<p><span style="font-size: 10pt;">3)</span><span style="font-size: 7pt; color: rgb(31, 73, 125);"> </span>Unknown - No data received from
WMI: </p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal">I
am using the following the check commands </p>
<p class="MsoNormal">check_nrpe_mssql_log_used!*!50!90</p>
<p class="MsoNormal">check_nrpe_mssql_log_growths!*!5000!9000</p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal">Please
someone let me know how can I resolve this. </p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> <img src="cid:image001.png@01CB511D.091602D0" height="64" width="672"></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"><img src="cid:image002.png@01CB511D.091602D0" height="62" width="671"></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"><img src="cid:image004.png@01CB511D.091602D0" height="67" width="654"></span><span style="font-size: 10pt;"></span></p>
<p class="MsoNormal">Please see the service definition and command definition
which I am using for SQL-DB-LOG-USED and SQL-DB-LOG-GROWTH.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Request you to provide a clue on this.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">define service{</p>
<p class="MsoNormal">
use
generic-service ; Name of
service template to use</p>
<p class="MsoNormal">
host_name
abcd</p>
<p class="MsoNormal">
service_description
SQL-DB-LOG-USED</p>
<p class="MsoNormal">
is_volatile
0</p>
<p class="MsoNormal">
check_period
24x7</p>
<p class="MsoNormal">
max_check_attempts
3</p>
<p class="MsoNormal">
normal_check_interval
5</p>
<p class="MsoNormal">
retry_check_interval
1</p>
<p class="MsoNormal">
contact_groups
sql-admins</p>
<p class="MsoNormal">
notification_interval
0</p>
<p class="MsoNormal">
notification_period
24x7</p>
<p class="MsoNormal">
notification_options
c,r</p>
<p class="MsoNormal">
check_command
check_nrpe_mssql_log_used!*!50!90</p>
<p class="MsoNormal"> }</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">define service{</p>
<p class="MsoNormal">
use
generic-service ; Name of
service template to use</p>
<p class="MsoNormal">
host_name
abcd</p>
<p class="MsoNormal">
service_description
SQL-DB-LOG-GROWTH</p>
<p class="MsoNormal">
is_volatile
0</p>
<p class="MsoNormal">
check_period
24x7</p>
<p class="MsoNormal">
max_check_attempts
3</p>
<p class="MsoNormal">
normal_check_interval
5</p>
<p class="MsoNormal">
retry_check_interval
1</p>
<p class="MsoNormal">
contact_groups
sql-admins</p>
<p class="MsoNormal">
notification_interval
0</p>
<p class="MsoNormal">
notification_period
24x7</p>
<p class="MsoNormal">
notification_options
c,r</p>
<p class="MsoNormal">
check_command
check_nrpe_mssql_log_growths!*!5000!9000 ; Log growth scale is 0.01 hence 5000
and 9000</p>
<p class="MsoNormal"> }</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">define command {</p>
<p class="MsoNormal">
command_name
check_nrpe_mssql_log_used</p>
<p class="MsoNormal">
command_line
$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_used -a
$HOSTADDRESS$ "$ARG1$" "$ARG2$" "$ARG3$"</p>
<p class="MsoNormal">}</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">define command {</p>
<p class="MsoNormal">
command_name
check_nrpe_mssql_log_growths</p>
<p class="MsoNormal">
command_line
$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_growth -a
$HOSTADDRESS$ "$ARG1$" "$ARG2$" "$ARG3$"</p>
<p class="MsoNormal">}</p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Book Antiqua","serif"; color: black;">Thanks
& Regards,</span></p>
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Book Antiqua","serif"; color: black;">Ravi G</span></b></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Book Antiqua","serif"; color: black;"> </span></p>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><br>
------------------------------------------------------------------------------<br>
Automate Storage Tiering Simply<br>
Optimize IT performance and efficiency through flexible, powerful,<br>
automated storage tiering capabilities. View this brief to learn how<br>
you can reduce costs and improve performance.<br>
<a href="http://p.sf.net/sfu/dell-sfdev2dev" target="_blank">http://p.sf.net/sfu/dell-sfdev2dev</a><br>
_______________________________________________<br>
Nagios-users mailing list<br>
<a href="mailto:Nagios-users@lists.sourceforge.net" target="_blank">Nagios-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a><br>
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.<br>
::: Messages without supporting info will risk being sent to /dev/null</p>
</div>
<p class="MsoNormal"> </p>
</div>
</div>
<br>------------------------------------------------------------------------------<br>
Nokia and AT&T present the 2010 Calling All Innovators-North America contest<br>
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada<br>
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing<br>
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store<br>
<a href="http://p.sf.net/sfu/nokia-dev2dev" target="_blank">http://p.sf.net/sfu/nokia-dev2dev</a><br>_______________________________________________<br>
Nagios-users mailing list<br>
<a href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a><br>
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.<br>
::: Messages without supporting info will risk being sent to /dev/null<br></blockquote></div><br>