Location: PHPKode > projects > Network Asset Management Archive > nama/iaso/picks.php
<!--script language="JavaScript">
   var tool = java.awt.Toolkit;
   var size = new
         java.awt.Dimension(tool.getDefaultToolkit().getScreenSize());
   var myWidth = size.width;
   var myHeight = size.height;
</script-->


<?php
$now = date("m/j/y h:i:s",time());
include "../connect.php";

$now = date("j/m/y h:i:s",time());
?>
<html>
<head>
<title>Host List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#F9F3E0" text="#000000">
<form name="Host_list" method="post" action="pickedit.php">
<input type="hidden" name="Height" value='<? print '<script>'; 
print 'document.write(document.body.offsetHeight);'; 
print '</script>'; ?>'>
  <p> Please select the labs you wish
   
    <select name="LABlist[]" size="8" multiple>
<?
$stmt = "Select * FROM LAB;";
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object($sth)) {

      echo '<option value="' . $row->SERIAL . '">' . $row->LAB . '</option>';
}
?>
    </select>
  </p>
  <p>And/Or Select Subnets
   
    <select name="SUBNET[]" size="4" multiple>
<?
$stmt = "Select distinct SUBNET from ARP_TABLE order by IPNUM;";
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object($sth)) {

      echo '<option value="' . $row->SUBNET . '">' . $row->SUBNET . '</option>';
}
?>

</select>
  </p>
  <p>And/Or select an OS.
 
    <select name="OSlist[]" size="8" multiple>
<?
ibase_free_result($sth);
$stmt = "Select distinct OS FROM ARP_TABLE;";
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object($sth)) {
   if ($row->OS != ''){
      echo '<option value="' . $row->OS . '">' . $row->OS . '</option>';
}	
}
ibase_free_result($sth);
ibase_close($dbh);
?>
  
  </select>
  </p>
  <p>
Select Group Order
  <select name="sortorder">
    <option value="LAB" selected>LAB</option>
    <option value="OS">OS</option>
  </select>
  </p>
  <p>
    <input type="submit" name="Submit" value="Generate List">
    <input type="submit" name="Submit3" value="No Green">
    <input type="submit" name="Submit4" value="On Update Server">
    <input type="submit" name="Submit5" value="Not On Update Server">
    <input type="submit" name="Submit6" value="Not On NAV  Server">
    <input type="submit" name="Submit7" value="VIRUS FOUND">
    <input type="submit" name="Submit8" value="VIRUS FOUND2">
    <input type="submit" name="Submit9" value="CAC INSTALLED">
    <input type="submit" name="Submit10" value="NO CAC">
    <input type="submit" name="Submit11" value="CRD2">
    <input type="reset" name="Submit2" value="Reset">
 </p>
IASO &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp SA/End User<br>
 <Select name="IASO[]" size="5" multiple>
<?
$stmt2 = "SELECT  O3.DISPLAY_NAME , O3.SERIAL, o3.phone FROM  OWNER o3, IASO i, LAB l WHERE (I.LIASO_NO = L.SERIAL) AND (I.USER_NO = O3.SERIAL)  order by display_name";
$sth2 = ibase_query($dbh, $stmt2);
while ($row2 = ibase_fetch_object($sth2)) {
   if ($row2->SERIAL != '14122') {
      print '<option value="' . $row2->SERIAL . '"';
      print '>' . $row2->DISPLAY_NAME . ' (' . $row2->PHONE . ')' . '</option>';
   }
}
?> </select>
 <Select name="SA[]" size="5" multiple>
<?
$stmt2 = "SELECT  O3.DISPLAY_NAME , O3.SERIAL, o3.phone FROM  OWNER o3 WHERE (serial in (select distinct owner from arp_table)) or (serial in (select distinct system_user from arp_table)) order by display_name";
$sth2 = ibase_query($dbh, $stmt2);
while ($row2 = ibase_fetch_object($sth2)) {
   if ($row2->SERIAL != '14122') {
      print '<option value="' . $row2->SERIAL . '"';
      print '>' . $row2->DISPLAY_NAME . ' (' . $row2->PHONE . ')' . '</option>';
   }
}
?> </select>

</form>
</body>
</html>
Return current item: Network Asset Management Archive