seigafuse.com

<?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 :)
?>