\n"; else echo "\n"; ?>

Grid statistics

Note
Next stats are dynamically extracted and represent data still in the server
(i.e. removed jobs are out of these statistics)

Job/worker/day

Back to workers stats

Job/day/worker

\n"; $queryRunning = "select count(*) from hosts,tasks"; /* $queryRunning = $queryRunning." where tasks.status='RUNNING' and tasks.host=hosts.uid and hosts.name='".$rowsHost["name"]."'"; */ $queryRunning = $queryRunning." where tasks.status='RUNNING' and tasks.host=hosts.uid and hosts.name='".$rowsHost["name"]."'"; $resultRunning = dbQuery ($connection, $queryRunning); $rowsRunning = mysql_fetch_array($resultRunning); /* $queryCompleted = "select count(*) from hosts,tasks"; $queryCompleted = $queryCompleted." where tasks.status='COMPLETED' and tasks.host=hosts.uid and hosts.name='".$rowsHost["name"]."'"; $resultCompleted = dbQuery ($connection, $queryCompleted); $rowsCompleted = mysql_fetch_array($resultCompleted); */ /* if(($rowsCompleted["count(*)"] < 1) && ($rowsRunning["count(*)"] < 1) && ($rowsHost["delai"] > 4500)) { continue; } */ $contentClass = "CONTENT".(($i % 2) + 1); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "\n"; echo "\n"; $i++; } ?>

4500)) $couleur = "red"; ?>

"; echo "\n"; $queryWorker = "select apps.name as app,tasks.laststartdate as sdate,tasks.removaldate as cdate,tasks.status as status from hosts,tasks,apps"; $queryWorker = $queryWorker." where tasks.host=hosts.uid and hosts.uid='".$WORKER."'"; $queryWorker = $queryWorker." and tasks.app=apps.uid order by tasks.laststartdate"; $resultWorker = dbQuery ($connection, $queryWorker); $i = 0; while ($rowsWorker= mysql_fetch_array($resultWorker)) { echo "\n"; echo "\n"; echo "\n"; if (isset ($rowsWorker["cdate"])) echo "\n"; else echo "\n"; echo "\n"; echo "\n"; } echo "

Jobs/workers

COMPLETED (RUNNING)

"; echo $rowsWorker["name"]." : "; echo "".$rowsWorker["os"]."; ".$rowsWorker["cputype"]."; ".$rowsWorker["cpuspeed"]."Mhz
"; echo "Ping : ".$rowsWorker["lastAlive"].""; echo "

Application Start date Completion date Status
".$rowsWorker["app"]." ".$rowsWorker["sdate"]." ".$rowsWorker["cdate"]." n/a ".$rowsWorker["status"]."
"; echo "

Back to workers stats
\n"; return; } // end of if (isset($WORKER)) /* $queryHost = "select *,now()-lastAlive as delai from hosts having delai<=4500"; $queryHost = "select *,now()-max(lastAlive) as delai from hosts group by name,ipaddr"; */ $queryHost = "select *,unix_timestamp(now())-unix_timestamp(max(lastAlive)) as delai from hosts group by name,ipaddr"; $queryHost = $queryHost." order by name"; $resultHost = dbQuery ($connection, $queryHost); $i = 0; while ($rowsHost= mysql_fetch_array($resultHost)) { echo "
\n
\n"; /* echo $rowsCompleted["count(*)"]."  (".($rowsRunning["count(*)"] == "" ? 0 : $rowsRunning["count(*)"]).") "; */ echo ($rowsHost["nbJobs"] == "" ? 0 : $rowsHost["nbJobs"])."  (".($rowsRunning["count(*)"] == "" ? 0 : $rowsRunning["count(*)"]).") "; echo "
\n
\n"; $couleur[$rowsHost["name"]] = "#16e82a"; if ($rowsHost["available"] == "false") $couleur[$rowsHost["name"]] = "#b48622"; if ($rowsHost["active"] == "false") $couleur[$rowsHost["name"]] = "gray"; if (($rowsHost["delai"] == "") || ($rowsHost["delai"] > 4500)) $couleur[$rowsHost["name"]] = "red"; echo "".$rowsHost["name"]."
\n
\n"; echo "details
\n
\n"; echo "".$rowsHost["os"]." ; ".$rowsHost["cpunb"]." CPUs ; ".$rowsHost["cpuspeed"]."Mhz \n"; if (substr($rowsHost["ipaddr"], 0, 7) == "134.158") { if(substr($rowsHost["ipaddr"], 0, 10) == "134.158.92") echo "IPN"; if(substr($rowsHost["ipaddr"], 0, 11) == "134.158.121") echo "LPC - Clermont Ferrand"; if((substr($rowsHost["ipaddr"], 8, 2) == "88") || (substr($rowsHost["ipaddr"], 8, 2) == "89") || (substr($rowsHost["ipaddr"], 8, 2) == "90") || (substr($rowsHost["ipaddr"], 8, 2) == "91")) echo "LAL"; } else if (substr($rowsHost["ipaddr"], 0, 9) == "129.175.7") echo "LRI"; else if (substr($rowsHost["ipaddr"], 0, 6) == "82.226") echo "proxad.net"; else if (substr($rowsHost["ipaddr"], 0, 5) == "81.66") echo "noos.fr"; else if (substr($rowsHost["ipaddr"], 0, 7) == "192.168") echo "private network"; echo "

Job/worker

Job/worker/day

\n"; if ($date != $rows["left(tasks.startdate,10)"]) { $date = $rows["left(tasks.startdate,10)"]; echo ""; echo "\n"; echo "\n"; } $contentClass = "CONTENT".(($i % 2) + 1); echo "\n"; $contentClass = "CONTENT".(($i % 2) + 1); echo "\n"; ?>

Jobs/day/worker

\n"; echo "
".$date."
\n"; echo "
\n"; echo "
\n"; echo $rows["host"]; echo "
\n"; echo " \n"; echo "
\n"; echo $rows["count(*)"]; echo "
\n"; echo "

Job/worker

Job/day/worker

\n"; if ($worker != $rows["host"]) { $worker = $rows["host"]; echo ""; echo "\n"; echo "\n"; } $contentClass = "CONTENT".(($i % 2) + 1); echo "\n"; $contentClass = "CONTENT".(($i % 2) + 1); echo "\n"; ?>

Jobs/worker/day

\n"; echo "\n"; echo "
".$worker."  top
\n"; echo "
\n"; echo "
\n"; echo $rows["left(tasks.startdate,10)"]; echo "
\n"; echo " \n"; echo "
\n"; echo $rows["count(*)"]; echo "
\n"; echo "

Job/worker

Job/day/worker

Job/worker/day

Jobs/day/worker
\n"; echo " ".$date." \n"; echo "
\n"; echo " \n"; echo $rows["host"]; echo " \n"; echo "	\n"; echo " \n"; echo $rows["count(*)"]; echo " \n"; echo "

Jobs/worker/day
\n"; echo "\n"; echo " ".$worker." top \n"; echo "
\n"; echo " \n"; echo $rows["left(tasks.startdate,10)"]; echo " \n"; echo "	\n"; echo " \n"; echo $rows["count(*)"]; echo " \n"; echo "