#!/usr/bin/php -q
<?php
#
# check_cuda - nagios plugin
#
#
# Copyright (C) 2007 Mike Seigafuse
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
#
# Report bugs to: mike@seigafuse.net
#
# This script will check counters of a Barracuda Spam Firewall using PHP SNMP functions
# and return them along with the status.
#
$numbparams = sizeof($argv);
# should be 5
if ($numbparams < 5 ) {
	echo "Usage: check_cuda <host ip> <community string> <queue> <warn> <crit>\\n";
	echo "     Queue can be either in, out or bounce\\n";
	echo "     Warning and Critical values should be positive integers\\n";
	exit;
}
$host = $argv[1];
$cstring = $argv[2];
$checkqueue = strtoupper($argv[3]);
$warn = $argv[4];
$crit = $argv[5];
 
$mailinqueue = "1.3.6.1.4.1.2021.8.1.101.1";
$mailoutqueue = "1.3.6.1.4.1.2021.8.1.101.2";
$mailbouncequeue = "1.3.6.1.4.1.2021.8.1.101.3";
 
function getsnmpvalue($host, $cstring, $oid) {
     $valuestring = snmpget($host, $cstring, $oid);
     $colpos = strpos($valuestring, ":");
     $subvalue = trim(substr($valuestring, $colpos+1));
     return $subvalue;
}
 
# Ready set go, time to do the real work
 
if ($checkqueue == "IN") {
	$queuelen = getsnmpvalue($host, $cstring, $mailinqueue);
} elseif ($checkqueue == "OUT") {
         $queuelen = getsnmpvalue($host, $cstring, $mailoutqueue);
} elseif ($checkqueue == "BOUNCE") {
         $queuelen = getsnmpvalue($host, $cstring, $mailbouncequeue);
}
if ($queuelen < $warn) {
	$format = '%s OK - %d messages queued |Mail%sQueue=%d;%d;%d';
	printf($format, $checkqueue, $queuelen, $checkqueue, $queuelen, $warn, $crit);
	exit(0);
}
if (($queuelen > $warn) && ($queuelen < $crit)) {
	$format = '%s Warning - %d messages queued |Mail%sQueue=%d;%d;%d';
	printf($format, $checkqueue, $queuelen, $checkqueue, $queuelen, $warn, $crit);
	exit(1);
}
if ($queuelen > $crit) {
	$format = '%s Critical - %d messages queued |Mail%sQueue=%d;%d;%d';
	printf($format, $checkqueue, $queuelen, $checkqueue, $queuelen, $warn, $crit);
	exit(2);
}
 
?>

<?php
# ocsdiff configuration file
#
# Database host
$dbhost = "localhost";
$dbname = "ocsweb";
$dbuser = "ocs";
$dbpass = "XXX";
$adminemail = "admin@yourdomain.tld";
$diskthreshold = 5; # percentage free space threshold
$domains = array(
		0 => array(
			'name' => 'XXXXX',
			'email' => "fred@yourdomain.tld,barney@yourdomain.tld"),
		1 => array(
			'name' => 'YYYYY',
			'email' => "wilma@yourdomain.tld"),
		2 => array(
			'name' => 'ZZZZZ',
			'email' => "betty@yourdomain.tld"));
$diskdomains = array(
		0 => array(
			'name' => 'XXXXX',
			'email' => "fred@yourdomain.tld,barney@yourdomain.tld"),
		1 => array(
			'name' => 'YYYYY',
			'email' => "wilma@yourdomain.tld"),
		2 => array(
			'name' => 'ZZZZZ',
			'email' => "betty@yourdomain.tld"));
?>

<?php
# This program will generate a daily report of disks with free space
# below a threshold set in the configuration file 
# Written by Mike Seigafuse July 2007
#
# Get the configuration file
require_once("ocsdiff_conf.php");
# Initialize headers so that email will be readable as Excel attachment
$today = date("Y-m-d G:i:s");
$headers = "From: ITInventory@yourdomain.tld\\r\\n";
$headers .= "Reply-To: ITInventory@yourdomain.tld\\r\\n";
$headers .= "MIME-Version: 1.0\\r\\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\\r\\n";
$headers .= "Content-type: application/vnd.ms-excel\\r\\n";
$headers .= "Content-disposition: attachment; filename=$today.csv\\r\\n";
# Connect to database
$link = mysql_connect("$dbhost", "$dbuser", "$dbpass")
    or die("Could not connect : " . mysql_error());
mysql_select_db("$dbname") or die("Could not select database");
# Now loop through the defined disk domains and prepare report 
for($i = 0; $i < sizeof($diskdomains); $i++) {
	$entry = $diskdomains[$i];
	$name = $entry['name'];
	$email = $entry['email'];
	$subject = "Daily Disk Utilization Report for domain $name";
	$msg = "Computer Name,Drive Letter,Type,Filesystem,Total,Free,Free %\\n";
	# Now we have the domain name and contact, next get a current list of
	# deviceIDs from this domain
	$query = "select id, name, userid from hardware where workgroup='$name' and osname like '%server%'";
	$deviceresults = mysql_query($query)  or die("Query failed : " . mysql_error());
	while ($line = mysql_fetch_array($deviceresults, MYSQL_ASSOC)) {
		$deviceid = $line['id'];
		$computername = rtrim($line['name']);
		# Disk checking section
		$query = "select letter, type, filesystem, total, free
			from drives
			where hardware_id='$deviceid' and
			type = 'Hard Drive'";
		$diskresults = mysql_query($query)  or die("Query failed : " . mysql_error());
		# All information is now collected, now generate output 
		while ($diskline = mysql_fetch_array($diskresults, MYSQL_ASSOC)) {
			$driveletter = $diskline['letter'];
			$drivetype = $diskline['type'];
			$drivefs = $diskline['filesystem'];
			$drivetotal = $diskline['total'];
			$drivefree = $diskline['free'];
			$freeperc = (($drivefree/$drivetotal) * 100);
			if ($freeperc < $diskthreshold) {
				$msg .= "$computername,$driveletter,$drivetype,$drivefs,$drivetotal,$drivefree,$freeperc\\n";
				}
			} # end of disk loop
		} # end of devices in a domain loop
	# send out the email for this domain
	if ($msg == "") $msg = "No disk space issues found\\n";
	mail("$email", $subject, $msg, $headers);
	} # end of domain loop
# Almost done, just need to free up result memory
mysql_free_result($deviceresults);
mysql_free_result($diskresults);
# The End :)
?>