#!/usr/bin/php
<?php

#################
# check_bex_media
#    Version 1.0 beta
#    by Christian Arnold, arctic-media.de
#
# With this Nagios plugin you are able to check if a Symantec
# BackupExec Server needs a media change (new DLT Tape, ...).
#
# You'll need SQL-Auth on the MS-SQL-Server with SELECT allowed
# for a user on the responsible database.
#
#################
#
# LICENSE
#
# This Script is licensed under the 
# Creative Commons Attribution-Share Alike 3.0 License. You can
# find the License here: http://creativecommons.org/licenses/by-sa/3.0/
#
#################
# Changelog
#
# v1.0 beta
#  - Initial release
################


#################
# Definitions and Functions
#################

//Default Values
$dbHost = 'backuple';
$dbInstance = 'bkupexec';
$dbUser = '';
$dbPassword = '';
$dbDatabase = 'BEDB';
$fullMsg = false;

// Function to validate a command line option
function check_cli_arg($option, $i) {
	// If the option requires an argument but one isn't sent, bail out
	$next_offset = $i + 1;
	if (!isset($_SERVER['argv'][$next_offset]) || substr($_SERVER['argv'][$next_offset], 0, 1) == "-") {
		print "UNKNOWN: The \"$option\" option requires a value.\n";
	exit(3);
	} else {
		${$option} = $_SERVER['argv'][++$i];
		return ${$option};
	}
}

// Function to display usage information
function usage() {
	echo "USAGE: check_bex_media -H <Hostname|IP> [-i <MSSQL Instance Name>] -u <DB user> -p <DB password> [-d <DB name>] [--long]\n";
	exit();
}

// Function to display version information
function version() {
	echo "check_bex_media v0.1 beta\n";
	exit();
}

function help() {
	echo <<<EOF
check_bex_media v0.1 beta

Nagios Plugin to check a BackupExec Server if a medium has to be changed

Possible Parameters
===================

Generic:
  -h
  --help       Shows this message
	
  -V
  --version    Displays version information
	
Checking:
  -H           Set the Hostname/IP of the server containing the BackupExec Database
	
  -i           The SQL-Server instance name where the BackupExec Database is in 
               (Defaults to "bkupexec")
	
  -u           Name of the user
	
  -p           Password to connect
	
  -d           Database to connect to (Defaults to "BEDB")
	
  --long       For the full message of BackupExec as additional info


EOF;
	exit();
}

################
# Main Code
################

// If no options are set, display the help
if ($_SERVER['argc'] == 1) {
	print "Could not parse arguments\n";
	usage();
	exit;
}

//Go through the given options
for ($i = 1; $i < $_SERVER['argc']; $i++) {
	$arg = $_SERVER["argv"][$i];
	switch($arg) {
		case '-h':
		case '--help':
			help();
			break;

		case '-V':
		case '--version':
			version();
			break;

		case '-H':
			$dbHost = check_cli_arg($_SERVER["argv"][$i], $i);
			break;

		case '-i':
			$dbInstance = check_cli_arg($_SERVER["argv"][$i], $i);
			break;

		case '-u':
			$dbUser = check_cli_arg($_SERVER["argv"][$i], $i);
			break;

		case '-p':
			$dbPassword = check_cli_arg($_SERVER["argv"][$i], $i);
			break;

		case '-d':
			$dbDatabase = check_cli_arg($_SERVER["argv"][$i], $i);
			break;

		case '--long':
			$fullMsg = true;
			break;
	}
}

//Check if the required options are set
if($dbUser == "") {
	echo "No username set!";
	exit(3);
}
if($dbPass = "") {
	echo "No password set!";
	exit(3);
}

//Do the SQL magic
$dbSql = "SELECT     AlertID, AlertDate, SourceMachine, AlertTitle, AlertMessage, HasExtendedMessage, 
                      ExtendedMessage, UserResponse, ResponseMachine, DeviceName, JobName
FROM         Alert
WHERE     (AppEventID = 58061) AND (AlertClearedByUser = 0)";

$conn = @mssql_connect($dbHost.'\\'.$dbInstance, $dbUser, $dbPassword);
if($conn) {
	$selDb = @mssql_select_db($dbDatabase);
	if($selDb) {

		$result = @mssql_query($dbSql);
		if($result) {

			if(mssql_num_rows($result) == 0) {
				echo "OK: No media change required\n";
				$exitCode = 0;
			} else {
				$data = mssql_fetch_array($result);
				if($fullMsg == true) {
					if($data['HasExtendedMessage'] == 'TRUE')
						$message = $data['AlertMessage'].$data['ExtendedMessage'];
					else
						$message = $data['AlertMessage'];
				} else {
					$message = substr($data['AlertMessage'], 0, strpos($data['AlertMessage'], "\n"));
				}
				echo "WARNING: ".$data['AlertTitle']."\n Message: ".$message."\nSource: ".$data['SourceMachine']."\nJob: ".$data['JobName']."\nDevice: ".$data['DeviceName'];
				$exitCode = 1;
			}
		} else {
			echo "CRITICAL: Couldn't query DB (".mssql_get_last_message().")\n";
			$exitCode = 2;
		}
	} else {
		echo "CRITICAL: Couldn't select database '".$dbDatabase."' (".mssql_get_last_message().")\n";
		$exitCode = 2;
	}
} else {
	echo "CRITICAL: Couldn't connect to '".$dbHost.'\\'.$dbInstance."' as user ".$dbUser." (".mssql_get_last_message().")\n";
	$exitCode = 2;
}
exit($exitCode);