I use the "PDF-Report (Full)" function of OpenAudIT as part of my Disaster Recovery plan. The information it provides is outstanding, and the format is fantastic.
I work in a rather small environment(~15 servers) and would love to be able to have the system report ran for all of the servers with a single command. My php skills are sorely lacking... Here is the snippet of code in the script that i think needs be modified:
[code]//Get the pc's to display
//actually only one
if(isset($_REQUEST["pc"]) AND $_REQUEST["pc"]!=""){
$pc=$_REQUEST["pc"];
$_GET["pc"]=$_REQUEST["pc"];
$sql = "SELECT system_uuid, system_timestamp, system_name FROM system WHERE system_uuid = '$pc' OR system_name = '$pc' ";
$result = mysql_query($sql, $db);
$i=0;
if ($myrow = mysql_fetch_array($result)){
do{
$systems_array[$i]=array("pc"=>$myrow["system_uuid"],
"system_timestamp"=>$myrow["system_timestamp"],
);
$i++;
}while ($myrow = mysql_fetch_array($result));
}
}else{
$systems_array[0]=array("pc"=>"","system_timestamp"=>"",);[/code]
It appears that the looping code is in place, it just needs to be modified to loop through a group of machines. Is this something that would be easy to do? Can someone point me in the right direction to make this happen?
Thanks in advance for any advice
jonz