Custom Counters with SQL

[Paul Bourgeau]

Sorry, I fat fingered.  Misspelled database and was missing a space
between Size and (KB).

 
 
Thank You,
Paul Bourgeau
 
Ph: 262-523-3300 x60279
Fx: 208-898-2371
psbourgeau at mpccorp.com
 
 
 
 

-----Original Message-----
From: nagios-users-admin at lists.sourceforge.net
[mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of Paul
Bourgeau
Sent: Wednesday, February 16, 2005 1:34 PM
To: nagios-users at lists.sourceforge.net
Subject: [Nagios-users] Custom Counters with SQL

I am trying to set up some custom SQL counters to pull from Performance
monitor and I keep getting a 0 value.  Even when I run the command from
the command line and I still get a value of 0.  Can anyone give me a
hand?  Thanks,
Paul


Here's what I have so far:

checkcommands.cfg
define command{
        command_name    check_mvagent_SQL_DB_Size
        command_line    $USER1$/check_nt -H $HOSTADDRESS$ -v COUNTER -l
"\\SQLServer:Datadases(_Total)\\Data File(s) Size(KB)","Total Database
Size: %.f" -w $ARG1$ -c $ARG2$ -s $ARG3$
        }

services.cfg
# SQL DBase Size check_mvagent_SQL_DB_Size
##############TEST#############
define service{
        use                             notify-service          ; Name
of service template to use
        host_name                       SQLserver
        service_description             TESTING - SQL Dbase Size
        is_volatile                     0
        check_period                    24x7
        max_check_attempts              5
        normal_check_interval           1
        retry_check_interval            1
        contact_groups                  group-statuslog
        notification_interval           30
        notification_period             24x7
        notification_options            c,w,u,r
        check_command
check_mvagent_SQL_DB_Size!85!95!passwd
        }


Disclaimer: 16/2/2005

MPC Computers is providing the following information in compliance with
federal regulations:
 
MPC Computers, LLC
906 E. Karcher Road
Nampa, Idaho 83687
1-888-224-4247
http://www.mpccorp.com

To discontinue receiving e-mail communications from MPC in the future,
please go to: 
http://www.mpccorp.com/email/manage.html and follow the instructions.





-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=ick
_______________________________________________
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


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
_______________________________________________
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