SQL Server alert

[qmo.or]

Hello,

I would know if it's possible to create an alert based on a SQL request.

For example : a request give me a result of 37 and my alert'll be critical if the result is superior to 40.
If it's possible, i'll search more to find the good way to do that.

Thanks in advance.

[mcapra]

check_mysql_query is included with nagios-plugins:

Code: Select all

[root@nagios ~]# /usr/local/nagios/libexec/check_mysql_query -h
check_mysql_query v2.2.1.6.g4103.dirty (nagios-plugins 2.2.1)
Copyright (c) 1999-2014 Nagios Plugin Development Team
        <devel@nagios-plugins.org>

This program checks a query result against threshold levels


Usage:
 check_mysql_query -q SQL_query [-w warn] [-c crit] [-H host] [-P port] [-s socket]
       [-d database] [-u user] [-p password] [-f optfile] [-g group]

Options:
 -h, --help
    Print detailed help screen
 -V, --version
    Print version information
 --extra-opts=[section][@file]
    Read options from an ini file. See
    https://www.nagios-plugins.org/doc/extra-opts.html
    for usage and examples.
 -q, --query=STRING
    SQL query to run. Only first column in first row will be read
 -w, --warning=RANGE
    Warning range (format: start:end). Alert if outside this range
 -c, --critical=RANGE
    Critical range
 -H, --hostname=ADDRESS
    Host name, IP Address, or unix socket (must be an absolute path)
 -P, --port=INTEGER
    Port number (default: 3306)
 -s, --socket=STRING
    Use the specified socket (has no effect if -H is used)
 -d, --database=STRING
    Database to check
 -f, --file=STRING
    Read from the specified client options file
 -g, --group=STRING
    Use a client options group
 -u, --username=STRING
    Username to login with
 -p, --password=STRING
    Password to login with
    ==> IMPORTANT: THIS FORM OF AUTHENTICATION IS NOT SECURE!!! <==
    Your clear-text password could be visible as a process table entry

 A query is required. The result from the query should be numeric.
 For extra security, create a user with minimal access.

Notes:
 You must specify -p with an empty string to force an empty password,
 overriding any my.cnf settings.

Send email to help@nagios-plugins.org if you have questions regarding use
of this software. To submit patches or suggest improvements, send email to
devel@nagios-plugins.org

Depending on what guide you followed to install Nagios Core, you should already have the standard nagios plugins installed. If not, this KB article has a "Installing The Nagios Plugins" section:
https://support.nagios.com/kb/article/n ... ource.html

[dwhitfield]

@qmo.or, did you have any other questions? I 100% agree with @mcapra's post above. We'd need an error message from you before I could add more info.