Custom Counters with SQL

[Paul Bourgeau]

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=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