Location: PHPKode > projects > Network Asset Management Archive > nama/iaso/summaryiaso.php
<?php
include "../connect.php";
print '<body bgcolor="#F9F3E0">';
$now = date("j/m/y h:i:s",time());
$IASO = $_GET['iaso'];
$LAB=1;
$stmtiaso="select O3.DISPLAY_NAME, O3.PHONE from OWNER O3 where (o3.serial = '$IASO');";
       //echo $stmtiaso . '<br>';
$sthiaso = ibase_query($dbh, $stmtiaso);
$rowiaso = ibase_fetch_object($sthiaso);
$LIASO=$rowiaso->DISPLAY_NAME;
$LIASO_PHONE=$rowiaso->PHONE;
$mymsg = "";
$mymsg .= '<H1>' . $LIASO . '</H1><br>';
$headers  = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "From: " . $EMAIL;

$tablerow = "style='border-color:#DBB748; border-width:1px; border-right: 2px solid #DBB748; border-collapse: collapse; border-style:solid;'";
$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";
//echo $stmt;
$sth = ibase_query($dbh, $stmt);
$i = -1;
$first = 1;
$myhtml = '<html><body text="#000000" bgcolor="#F9F3E0" link="#0000EE" vlink="#551A8B" alink="#FF0000">';
$ip="";
$i = -1;
while ($row = ibase_fetch_object($sth)) {
    if ($i==-1) {
        $empty=1;
        $mymsg .= '<H1>Red Machines</H1><br><table style="border-color:#DBB748; border-width:3px; border-right: 3px solid #DBB748; border-collapse: collapse; border-style:solid;" width="700" border="2">';
        $mymsg .= "<tr BGCOLOR='#DBB748' ALIGN=left><th " . $tablerow . ">IP</th><th " . $tablerow . ">Name</th><th " . $tablerow . ">Building</th><th " . $tablerow . ">Room</th><th " . $tablerow . ">Bar Code</th><th " . $tablerow . ">OS</th><th " . $tablerow . ">Last Seen</th></tr>";
    }
    $mymsg .= '<input type="hidden" name="serial[]" value="' . $row->SERIAL . '">';
    if ($i%2) {
        $mymsg .= "<tr BGCOLOR='#F5EACB'>";
        } else {
        $mymsg .= "<tr>";
    }
    list ($lastseendate, $lastseentime) = split(" ", $row->LAST_SEEN);
    
    $i = $i + 1;
    if ($i%2) {
        $mymsg .= "<tr BGCOLOR='#F5EACB'>";
        } else {
        $mymsg .= "<tr>";
    }
    $mymsg .= '<td ' . $tablerow . 'width="15%"><a href="/right.php?SERIAL=' . $row->MD5 . '" target = "_blank">' . $row->IP_ADDRESS . '</a></td>';
    if ($row->NETBIOS_NAME!='') {
        $mymsg .= '<td ' . $tablerow . '>' . $row->NETBIOS_NAME . '</td>';
        } else {
        $mymsg .= '<td ' . $tablerow . '>' . $row->DNS_NAME . '</td>';
    }
    $mymsg .= '<td ' . $tablerow . '>' . $row->BUILDING . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->ROOM . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->BARCODE . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->OS . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $lastseendate . '</td>';
    
    $mymsg .= '</tr>';
    $ip=$row->IP_ADDRESS;
}
$mymsg .= '</table>';

$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";
//echo $stmt;
$sth = ibase_query($dbh, $stmt);
$i = -1;
while ($row = ibase_fetch_object($sth)) {
    if ($i==-1) {
        $empty=1;
        $mymsg .= '<H1>Not on Update Server</H1><br><table style="border-color:#DBB748; border-width:3px; border-right: 3px solid #DBB748; border-collapse: collapse; border-style:solid;" width="800" border="2">';
        $mymsg .= "<tr BGCOLOR='#DBB748' ALIGN=left><th " . $tablerow . ">IP</th><th " . $tablerow . ">Name</th><th " . $tablerow . ">Building</th><th " . $tablerow . ">Room</th><th " . $tablerow . ">Bar Code</th><th " . $tablerow . ">OS</th><th " . $tablerow . ">Last Seen</th></tr>";
    }
    $mymsg .= '<input type="hidden" name="serial[]" value="' . $row->SERIAL . '">';
    if ($i%2) {
        $mymsg .= "<tr BGCOLOR='#F5EACB'>";
        } else {
        $mymsg .= "<tr>";
    }
    list ($lastseendate, $lastseentime) = split(" ", $row->LAST_SEEN);

    $i = $i + 1;
    if ($i%2) {
        $mymsg .= "<tr BGCOLOR='#F5EACB'>";
        } else {
        $mymsg .= "<tr>";
    }
    $mymsg .= '<td ' . $tablerow . 'width="15%"><a href="/right.php?SERIAL=' . $row->MD5 . '" target = "_blank">' . $row->IP_ADDRESS . '</a></td>';
    if ($row->NETBIOS_NAME!='') {
        $mymsg .= '<td ' . $tablerow . '>' . $row->NETBIOS_NAME . '</td>';
        } else {
        $mymsg .= '<td ' . $tablerow . '>' . $row->DNS_NAME . '</td>';
    }
    $mymsg .= '<td ' . $tablerow . '>' . $row->BUILDING . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->ROOM . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->BARCODE . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->OS . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $lastseendate . '</td>';

    $mymsg .= '</tr>';
    $ip=$row->IP_ADDRESS;
}
$mymsg .= '</table>';

$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";
//echo $stmt;
$sth = ibase_query($dbh, $stmt);
$i = -1;
while ($row = ibase_fetch_object($sth)) {
    if ($i==-1) {
        $empty=1;
        $mymsg .= '<H1>Not on Antivirus Server</H1><br><table style="border-color:#DBB748; border-width:3px; border-right: 3px solid #DBB748; border-collapse: collapse; border-style:solid;" width="800" border="2">';
        $mymsg .= "<tr BGCOLOR='#DBB748' ALIGN=left><th " . $tablerow . ">IP</th><th " . $tablerow . ">Name</th><th " . $tablerow . ">Building</th><th " . $tablerow . ">Room</th><th " . $tablerow . ">Bar Code</th><th " . $tablerow . ">OS</th><th " . $tablerow . ">Last Seen</th></tr>";
    }
    $mymsg .= '<input type="hidden" name="serial[]" value="' . $row->SERIAL . '">';
    if ($i%2) {
        $mymsg .= "<tr BGCOLOR='#F5EACB'>";
        } else {
        $mymsg .= "<tr>";
    }
    list ($lastseendate, $lastseentime) = split(" ", $row->LAST_SEEN);

    $i = $i + 1;
    if ($i%2) {
        $mymsg .= "<tr BGCOLOR='#F5EACB'>";
        } else {
        $mymsg .= "<tr>";
    }
    $mymsg .= '<td ' . $tablerow . 'width="15%"><a href="/right.php?SERIAL=' . $row->MD5 . '" target = "_blank">' . $row->IP_ADDRESS . '</a></td>';
    if ($row->NETBIOS_NAME!='') {
        $mymsg .= '<td ' . $tablerow . '>' . $row->NETBIOS_NAME . '</td>';
        } else {
        $mymsg .= '<td ' . $tablerow . '>' . $row->DNS_NAME . '</td>';
    }
    $mymsg .= '<td ' . $tablerow . '>' . $row->BUILDING . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->ROOM . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->BARCODE . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->OS . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $lastseendate . '</td>';

    $mymsg .= '</tr>';
    $ip=$row->IP_ADDRESS;
}
$mymsg .= '</table>';

$stmtav = "select max(virusdefdate) from arp_table";
$sthav = ibase_query($dbh, $stmtav);
$rowav = ibase_fetch_object($sthav);
$ANTIVIRUS=$rowav->MAX;

$stmt = "select a.* from arp_table a where (a.iaso = " . $IASO . ") and (OS starts with 'Win') and (av_server is not null) and (virusdefdate <> '$ANTIVIRUS') and (ip_address <> '0.0.0.0') and (laptop is null) order by a.iaso, a.ipnum";
//echo $stmt;
$sth = ibase_query($dbh, $stmt);
$i = -1;
while ($row = ibase_fetch_object($sth)) {
    if ($i==-1) {
        $empty=1;
        $mymsg .= '<H1>Antivirus Out of Date'. $ANTIVIURS.'</H1><br><table style="border-color:#DBB748; border-width:3px; border-right: 3px solid #DBB748; border-collapse: collapse; border-style:solid;" width="800" border="2">';
        $mymsg .= "<tr BGCOLOR='#DBB748' ALIGN=left><th " . $tablerow . ">IP</th><th " . $tablerow . ">Name</th><th " . $tablerow . ">Building</th><th " . $tablerow . ">Room</th><th " . $tablerow . ">Bar Code</th><th " . $tablerow . ">OS</th><th " . $tablerow . ">Last Seen</th><th " . $tablerow . ">Virus Server</th><th " . $tablerow . ">Definition Date</th></tr>";
    }
    $mymsg .= '<input type="hidden" name="serial[]" value="' . $row->SERIAL . '">';
    if ($i%2) {
        $mymsg .= "<tr BGCOLOR='#F5EACB'>";
        } else {
        $mymsg .= "<tr>";
    }
    list ($lastseendate, $lastseentime) = split(" ", $row->LAST_SEEN);

    $i = $i + 1;
    if ($i%2) {
        $mymsg .= "<tr BGCOLOR='#F5EACB'>";
        } else {
        $mymsg .= "<tr>";
    }
    $mymsg .= '<td ' . $tablerow . 'width="15%"><a href="/right.php?SERIAL=' . $row->MD5 . '" target = "_blank">' . $row->IP_ADDRESS . '</a></td>';
    if ($row->NETBIOS_NAME!='') {
        $mymsg .= '<td ' . $tablerow . '>' . $row->NETBIOS_NAME . '</td>';
        } else {
        $mymsg .= '<td ' . $tablerow . '>' . $row->DNS_NAME . '</td>';
    }
    $mymsg .= '<td ' . $tablerow . '>' . $row->BUILDING . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->ROOM . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->BARCODE . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->OS . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $lastseendate . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->AV_SERVER . '</td>';
    $mymsg .= '<td ' . $tablerow . '>' . $row->ANTIVIRUS . '</td>';

    $mymsg .= '</tr>';
    $ip=$row->IP_ADDRESS;
}
$mymsg .= '</table>';


echo $mymsg;
$mymsg = $myhtml . $mymsg;
if ($empty==0) {
   echo "All your machines are up to date";
}

//     echo 'Sent Email to ' . $iasoemail . ' , ' . $liasoemail . ' --------------------------------------------------<br>';
//     mail($iasoemail,$SUBJECT, $mymsg, $headers);
if ($iasoemail != $liasoemail) {
    //         mail($liasoemail,$SUBJECT, $mymsg, $headers);
}
?>
Return current item: Network Asset Management Archive