#!/bin/sh
#
# ## Plugin for Nagios to execute SQL string against Oracle DB
# ##
# ## - 2010-07-05 coded and tested for Linux
#
#
# ## You are free to use this script under the terms of the Gnu Public License.
# ## No guarantee - use at your own risc.
#
# ## Description:
#
# This plugin executes a specific SQL query against an Oracle DB using sqlplus.
#
# Paths to commands used in this script.  These
# may have to be modified to match your system setup.

PATH=""

find="/usr/bin/find"
xargs="/usr/bin/xargs"
tail="/usr/bin/tail"
awk="/usr/bin/awk"
cut="/usr/bin/cut"
wc="/usr/bin/wc"
grep="/bin/grep"
sqlplus="/usr/bin/sqlplus"

PROGNAME=`/usr/bin/basename $0`
PROGPATH=`echo $0 | /bin/sed -e 's,[\\/][^\\/][^\\/]*$,,'`
REVISION="Revision 1.0"
AUTHOR="(c) 2007 Bernd Mueller (http://www.lisega.de/)"

# Exit codes
STATE_OK=0
STATE_WARNING=1
STATE_CRITICAL=2
STATE_UNKNOWN=3
STATE_DEPENDENT=4

print_revision() {
    echo "$REVISION $AUTHOR"
}

print_usage() {
    echo "Usage: $PROGNAME"
    echo "Usage: $PROGNAME --help"
    echo "Usage: $PROGNAME --version"
}

print_help() {
    print_revision $PROGNAME $REVISION
    echo ""
    echo "Plugin for Nagios to run SQL query against Oracle DB using sqlplus"
    echo ""
    print_usage
    echo ""
}

# DB Query:

queryresult=`$sqlplus I2TM_CRP/infrsopo@I2A631P <<EOF
;
EOF`

# Check result:

result="ok"
exitstatus=$STATE_OK

##### Compare with thresholds

if [ "$queryresult" = "" ]; then
	echo ""
        result="critical"
        exitstatus=$STATE_CRITICAL;
else
	echo ""
	result="ok"
	exitstatus=$STATE_OK
fi

exit $exitstatus