Location: PHPKode > projects > Network Asset Management Archive > nama/iaso/golden.php
<?php
include "../connect.php";
print '<body bgcolor="#F9F3E0">';
$now = date("j/m/y h:i:s",time());
$IASO = $_GET['iaso'];
$LAB=1;
$empty=0;
$stmt = "select a.* from arp_table a where (a.iaso = " . $IASO . ") and ((owner is null) or (building is null) or (room is null) or (barcode is null) or (owner is null) or (os is null)) and (ip_address <> '0.0.0.0') order by a.iaso, a.ipnum";
$sth = ibase_query($dbh, $stmt);
$i = -1;
if ($row = ibase_fetch_object($sth)) {
        $empty=1;
}
$stmt = "select a.* from arp_table a where (a.iaso = " . $IASO . ") and (OS starts with 'Win') and (update_server is null) and (laptop is null) and (ip_address <> '0.0.0.0') order by a.iaso, a.ipnum";
$sth = ibase_query($dbh, $stmt);
if ($row = ibase_fetch_object($sth)) {
        $empty=1;
}
$stmt = "select a.* from arp_table a where (a.iaso = " . $IASO . ") and (OS starts with 'Win') and (av_server is null) and (ip_address <> '0.0.0.0') and (laptop is null) order by a.iaso, a.ipnum";
$sth = ibase_query($dbh, $stmt);
if ($row = ibase_fetch_object($sth)) {
        $empty=1;
}
$stmt = "select a.* from arp_table a where (a.iaso = " . $IASO . ") and (OS starts with 'Win') and (av_server is not null) and (antivirus<>'3/26/2004 rev. 7') and (ip_address <> '0.0.0.0') and (laptop is null) order by a.iaso, a.ipnum";
$sth = ibase_query($dbh, $stmt);
if ($row = ibase_fetch_object($sth)) {
        $empty=1;
}
if ($empty==0) {
   echo "All your machines are up to date";
}
?>
Return current item: Network Asset Management Archive