#!/usr/bin/php -q = '$startdate' and tr.date <= '$endtoday' order by ts.host, ts.date"; $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()); $SQLNumRows = pg_numrows($SQLQueryResults); if ( $SQLNumRows ) { $hosttext="LogReview Report for Period of $startdate to $endtoday\n"; $id = 0; for ( $loop = 0 ; $loop != $SQLNumRows ; $loop++ ) { $SQLQueryResultsObject = pg_fetch_object($SQLQueryResults,$loop) or die(pg_errormessage()."
\n"); if ($id != $SQLQueryResultsObject->tsummary_id) { $hosttext .= "\n\n=============================================================\n"; $hosttext .= "System: " .stripslashes(pgdatatrim($SQLQueryResultsObject->host)) . "\n" ; $hosttext .= "Report Date: ". pgdatatrim($SQLQueryResultsObject->reportdate) ."\n"; $id = $SQLQueryResultsObject->tsummary_id; $hosttext .= "=============================================================\n"; } else { $hosttext .= "-------------------------------------------------------------\n"; } $hosttext .= "Reviewer: ". sec_username($sec_dbsocket, $SQLQueryResultsObject->reviewer); $hosttext .= " Date: ". $SQLQueryResultsObject->reviewdate. "\n\n"; $hosttext .= stripslashes(pgdatatrim($SQLQueryResultsObject->comments)) ."\n"; } echo $hosttext; mail(REPORTADDRESS,"CLF Log Review Report",$hosttext); } else { echo "No results\n"; } pg_freeresult($SQLQueryResults) or die(pg_errormessage()); dbdisconnect($sec_dbsocket); dbdisconnect($dbsocket); ?>