<?php
$page = "";
include "include.php";
$time_start = microtime_float();
if (!empty($_POST['Perform'])) {
foreach ($_POST as $id) {
$query = "DELETE FROM other WHERE other_id = '" . $id . "'";
$result = mysql_query($query) or die("Query failed at delete stage. groups");
$query = "DELETE FROM nmap_ports WHERE nmap_other_id = '" . $id . "'";
$result = mysql_query($query) or die("Query failed at delete stage. nmap_ports");
}
}
$sql = "SELECT other_id, other_ip_address, other_network_name, other_description, other_type, other_timestamp FROM other ORDER BY other_ip_address ";
$result = mysql_query($sql, $db);
$bgcolor = "#FFFFFF";
echo "<td valign=\"top\">\r\n <div class=\"main_each\">";
if ($myrow = mysql_fetch_array($result)) {
echo "<form name=\"DeleteList\" id=\"DeleteList\" method=\"post\" action=\"" . $_SERVER["PHP_SELF"] . "\" >\r\n \r\n <script language=\"JavaScript\" TYPE=\"text/javascript\">\r\n function CheckUncheckAll(form){\r\n if(!form)\r\n return;\r\n var objElements = form.elements;\r\n if(!objElements)\r\n return;\r\n var countElements = objElements.length;\r\n if(!countElements)\r\n return;\r\n else\r\n for (var i = 1; i < countElements; i++){ \r\n eval(\"objElements[\" + i + \"].checked = objElements[1].checked\"); \r\n }\r\n }\r\n </script>\r\n \r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n <tr>\r\n <td class=\"contenthead\">" . __("Delete other Equipments") . "<br /> </td>\r\n </tr>\r\n </table>\r\n \r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n <tr>\r\n <td width=\"30%\"><input type=\"submit\" name=\"Perform\" id=\"Perform\" value=\"Delete selected other equipments\" onclick=\"return confirm('Do you really want to DELETE all selected other equipments?')\"></td>\r\n <td width=\"70%\"><input type=\"checkbox\" name=\"SetUnset\" id=\"SetUnset\" onClick=\"CheckUncheckAll(this.form);\" />Check/Uncheck all<br /></td> \r\n </tr>\r\n </table>\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n <tr> </tr>\r\n <tr>\r\n <td></td>\r\n <td class=\"contentsubtitle\">" . __("IP Address") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Hostname") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Description") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Type") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Date Audited") . "</td>\r\n </tr>\n";
do {
$bgcolor = change_row_color($bgcolor, $bg1, $bg2);
echo "<tr style=\"bgcolor:" . $bgcolor . ";\">\r\n <td width=\"5%\"><input type=\"checkbox\" name=" . $myrow["other_id"] . " id=" . $myrow["other_id"] . " value=" . $myrow["other_id"] . "></td>\r\n <td><a href=\"system.php?other=" . $myrow["other_id"] . "&view=other_system\">" . ip_trans($myrow["other_ip_address"]) . "</a></td>\r\n <td>" . $myrow["other_network_name"] . "</td>\r\n <td>" . $myrow["other_description"] . "</td>\r\n <td><img src=\"images/o_" . str_replace(" ", "_", $myrow["other_type"]) . ".png\" alt=\"\" border=\"0\" width=\"16\" height=\"16\" /></td>\r\n <td>" . return_date_time($myrow["other_timestamp"]) . "</td>\r\n </tr>\n";
} while ($myrow = mysql_fetch_array($result));
echo " </table>\r\n </form>";
} else {
echo "<p class=\"content\">No Other Systems in database.</p>\n";
}
echo "</div>\n";
echo __("This Page was generated in") . " " . number_format(microtime_float() - $time_start, 2) . " " . __("Seconds") . ".";
echo "</td>\n";
include "include_right_column.php";
if ($myrow = mysql_fetch_array($result)) {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"700\" class=\"content\">\n";
echo "<tr>";
echo "<td class=\"contenthead\"><img src=\"images/inv_software" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" />Previously Installed Software</td>\n";
echo "</tr>";
echo "<tr>";
echo "<td><a href=\"system_software_audit.php?sort=software_name&sub=au&pc=" . $pc . "\">Application Name</a></td>\n";
echo "<td align=\"center\"><a href=\"system_software_audit.php?sort=software_timestamp&sub=au&pc=" . $pc . "\">First Detected On</a></td>\n";
echo "<td align=\"center\"><a href=\"system_software_audit.php?sort=software_timestamp&sub=au&pc=" . $pc . "\">Last Detected On</a></td>\n";
echo "<td align=\"center\">Google</td>";
echo "</tr>";
do {
echo "<tr bgcolor=\"" . $bgcolor . "\"><td>";
echo $myrow["software_name"] . "</td>";
echo "<td align=\"center\">" . return_date_time($myrow["software_first_timestamp"]) . "</td>";
echo "<td align=\"center\">" . return_date_time($myrow["software_timestamp"]) . "</td>";
echo "<td align=\"center\"><a href=\"http://www.google.com/search?num=30&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&q=%22" . url_clean($myrow["software_name"]) . "%22&btnG=Search\"><img border=\"0\" alt=\"Google Search\" title=\"Google Search\" src=\"images/button_google.gif\" width=\"16\" height=\"16\" /></a></td>";
echo "</tr>";
if ($bgcolor == $bg2) {
$bgcolor = $bg1;
} else {
$bgcolor = $bg2;
}
} while ($myrow = mysql_fetch_array($result));
echo "</table>";
} else {
echo "<p class=\"menuhead\"> No Software uninstalled.</p>";
}
echo "</div>";
echo "</body>";
echo "</html> ";
echo "<tr>\n";
echo "<td><b>IP Address</b></td>\n";
echo "<td align=\"center\"><b>System Name</b></td>\n";
echo "<td align=\"center\"><b>Last Audit Date & Time</b></td>\n";
echo "</tr>\n";
do {
$count = $count + 1;
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\">\n";
echo "<td>" . ip_trans($myrow["net_ip_address"]) . "</td>\n";
echo "<td align=\"center\"><a href=\"system_summary.php?pc=" . $myrow["system_uuid"] . "\">" . $myrow["system_name"] . "</a></td>\n";
echo "<td align=\"center\">" . return_date_time($myrow["system_timestamp"]) . "</td>\n";
echo "</tr>";
} while ($myrow = mysql_fetch_array($result));
echo "</table>";
echo "</div>";
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">\n";
echo "<tr><td colspan=\"3\"><b>Systems: " . $count . "</b></td></tr>\n";
echo "</table>";
echo "</div>";
} else {
}
} else {
}
if ($show_partition_usage == "y") {
$SQL = "SELECT sys.system_name, sys.net_ip_address, par.partition_uuid, par.partition_volume_name, par.partition_caption, par.partition_free_space, par.partition_size, par.partition_timestamp FROM system sys, partition par WHERE par.partition_free_space < '{$partition_free_space}' AND sys.system_uuid = par.partition_uuid AND par.partition_timestamp = sys.system_timestamp ORDER BY sys.system_name, par.partition_caption";
$result = mysql_query($SQL, $db);
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr>";
if ($show_mac == "y") {
echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> <a href=\"system_summary.php?pc=" . $myrow["net_mac_address"] . "&sub=all\">" . $myrow["net_mac_address"] . " </td>\n";
} else {
}
echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . $myrow["net_ip_address"] . " </td>\n";
echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> <a href=\"system_summary.php?pc=" . $myrow["system_uuid"] . "&sub=all\">" . $myrow["system_name"] . "</a> </td>\n";
if ($show_os == "y") {
echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . $os_name . " </td>\n";
} else {
}
if ($show_date_audited == "y") {
echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . return_date_time($myrow['system_timestamp']) . " </td>\n";
} else {
}
// if ($show_type == "y") { echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . $img . " </td>\n"; } else {}
if ($show_description == "y") {
echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . $myrow["system_description"] . " </td>\n";
} else {
}
if ($show_domain == "y") {
echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . $myrow["net_domain"] . " </td>\n";
} else {
}
if ($sub == "2") {
echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . $myrow["system_memory"] . " </td>\n";
} else {
}
echo "<div class=\"main_each\">";
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">";
echo "<tr><td colspan=\"4\" class=\"contenthead\">Delete a PC.</td></tr>";
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
echo "<tr><td><b>IP Address</b></td><td><b>Name</b></td><td><b>Date Last Audited</b></td><td></td></tr>";
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\" height=\"24\">";
echo "<td>" . $myrow["net_ip_address"] . "</td>\n";
echo "<td>" . $myrow["system_name"] . "</td>\n";
echo "<td>" . return_date_time($myrow["system_timestamp"]) . "</td>\n";
echo "<td><a href=\"admin_pc_delete_2.php?pc=" . $myrow["system_uuid"] . "&sub=no\"";
echo " onmouseover=\"document.button" . str_replace("-", "", $myrow["system_name"]) . ".src='images/button_delete_over.png'\" ";
echo " onmousedown=\"document.button" . str_replace("-", "", $myrow["system_name"]) . ".src='images/button_delete_down.png'\"";
echo " onmouseout=\"document.button" . str_replace("-", "", $myrow["system_name"]) . ".src='images/button_delete_out.png'\"";
echo " onclick=\"Javascript:return confirm('Do you really want to DELETE this PC ?');\">";
echo "<img src=\"images/button_delete_out.png\" name=\"button" . str_replace("-", "", $myrow["system_name"]) . "\" width=\"58\" height=\"22\" border=\"0\" alt=\"\" />";
echo "</a></td></tr>\n\n";
} while ($myrow = mysql_fetch_array($result));
} else {
echo "<p class=\"contenthead\">No PCs have been audited.</p>";
}
echo "</table>";
?>
</div>
</body>
function ConvertSpecialField($myrow, $field, $db, $page)
{
if (!isset($field["name"])) {
return "";
}
switch ($field["name"]) {
case "system_os_name":
return determine_os($myrow[$field["name"]]);
case "net_dhcp_lease_obtained":
case "net_dhcp_lease_expires":
case "net_driver_date":
case "ldap_computers_timestamp":
case "ldap_users_timestamp":
return return_date($myrow[$field["name"]]);
case "net_speed":
return number_format($myrow[$field["name"]]) . " Mbps";
case "software_first_timestamp":
case "software_timestamp":
case "system_first_timestamp":
case "system_timestamp":
case "other_first_timestamp":
case "other_timestamp":
case "monitor_first_timestamp":
case "monitor_timestamp":
case "system_audits_timestamp":
case "system_last_boot":
case "log_timestamp":
return return_date_time($myrow[$field["name"]]);
case "system_system_type":
if ($page == "list") {
return determine_img($myrow["system_os_name"], $myrow[$field["name"]]);
} else {
return $myrow[$field["name"]];
}
case "other_type":
if ($page == "list") {
return "<img src=\"images/o_" . str_replace(" ", "_", $myrow[$field["name"]]) . ".png\" alt=\"\" border=\"0\" width=\"16\" height=\"16\"/>";
} else {
return $myrow[$field["name"]];
}
case "other_ip_address":
return ip_trans($myrow[$field["name"]]);
case "delete":
return "<img src=\"images/button_delete_out.png\" id=\"button" . rand(0, 999999999) . "\" width=\"58\" height=\"22\" border=\"0\" alt=\"\" />";
case "ldap_user_status":
return "<img src='../images/user_" . $myrow[$field["name"]] . ".gif'>";
case "ldap_computer_status":
return "<img src='../images/computer_" . $myrow[$field["name"]] . ".gif'>";
case "startup_location":
if (substr($myrow[$field["name"]], 0, 2) == "HK") {
return __("Registry");
}
case "percentage":
case "disk_percent":
return $myrow[$field["name"]] . " %";
case "system_memory":
case "video_adapter_ram":
case "hard_drive_size":
case "partition_size":
case "partition_free_space":
case "total_memory":
case "pagefile_initial_size":
case "pagefile_max_size":
return number_format($myrow[$field["name"]]) . " MB";
case "evt_log_file_size":
case "evt_log_max_file_size":
return number_format($myrow[$field["name"]]) . " KB";
case "video_current_number_colours":
return strlen(decbin($myrow[$field["name"]])) + 1 . " Bit";
case "video_current_refresh_rate":
return $myrow[$field["name"]] . " Hz";
case "firewall_enabled_domain":
case "firewall_enabled_standard":
case "firewall_disablenotifications_standard":
case "firewall_donotallowexceptions_standard":
case "firewall_disablenotifications_domain":
case "firewall_donotallowexceptions_domain":
if ($myrow[$field["name"]] == "1") {
return __("Yes");
}
if ($myrow[$field["name"]] == "0") {
return __("No");
}
return __("Profile Not Detected");
case "other_ip_address":
return ($myrow["other_ip_address"] == "" and !isset($_REQUEST["edit"])) ? "Not-Networked" : $myrow[$field["name"]];
case "net_dhcp_server":
return $myrow[$field["name"]] == "none" ? __("No") : __("Yes") . " / " . $myrow[$field["name"]];
case "auth_enabled":
case "auth_admin":
if ($myrow[$field["name"]] == "0") {
return __("No");
}
if ($myrow[$field["name"]] == "1") {
return __("Yes");
}
return $myrow[$field["name"]];
case "auth_hash":
return "*****";
case "other_linked_pc":
if (!isset($_REQUEST["edit"])) {
$result = mysql_query("SELECT system_name FROM system WHERE system_uuid='" . $myrow[$field["name"]] . "' AND system_uuid != '' ", $db);
return ($myrow3 = mysql_fetch_array($result)) ? $myrow3["system_name"] : $myrow[$field["name"]];
}
case "monitor_uuid":
if (!isset($_REQUEST["edit"]) or isset($_REQUEST["edit"]) and isset($field["edit"]) and $field["edit"] == "n") {
$result = mysql_query("SELECT system_name FROM system WHERE system_uuid = '" . $myrow[$field["name"]] . "' AND system_uuid != '' ", $db);
return ($myrow3 = mysql_fetch_array($result)) ? $myrow3["system_name"] : $myrow[$field["name"]];
}
default:
if (isset($myrow[$field["name"]])) {
return $myrow[$field["name"]];
}
}
return "";
}
$sound = mysql_fetch_array($result11); ?> <h1>Report for <?php echo $myrow['system_name']; ?> </h1> <div id="content"> <table border="0" cellpadding="2" cellspacing="0" class="content"> <tr><td colspan="2"><b>System Information</b></td></tr> <tr bgcolor="#F1F1F1"><td width="250">User Name: </td><td><?php echo $myrow['net_user_name']; ?> </td></tr> <tr><td>Date Audited: </td><td><?php echo return_date_time($myrow['system_timestamp']); ?> </td></tr> <tr bgcolor="#F1F1F1"><td>Time Zone: </td><td><?php echo $myrow['time_caption']; ?> </td></tr> <tr><td width="250">Registered Owner: </td><td><?php echo $myrow['system_primary_owner_name']; ?> </td></tr> <tr bgcolor="#F1F1F1"><td>UUID: </td><td><?php echo $myrow['system_uuid']; ?> </td></tr> <tr><td>Model: </td><td><?php
echo "<tr><td colspan=\"2\" class=\"contenthead\"><img src=\"images/inv_summary" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" />Summary</td></tr>\n";
echo "<tr bgcolor=\"#F1F1F1\"><td width=\"200\">Machine Name: </td><td>" . $myrow["system_name"] . "</td></tr>\n";
echo "<tr><td>Description: </td><td>" . $myrow["system_description"] . "</td></tr>\n";
echo "<tr bgcolor=\"#F1F1F1\"><td>Domain Role: </td><td>" . $myrow["net_domain_role"] . "</td></tr>\n";
echo "<tr><td>Registered User: </td><td>" . $myrow["system_registered_user"] . "</td></tr>\n";
echo "<tr bgcolor=\"#F1F1F1\"><td>Chassis Type: </td><td>" . $myrow["system_system_type"] . "</td></tr>\n";
echo "<tr><td>Model / Serial #: </td><td>" . $myrow["system_model"] . " / " . $myrow["system_id_number"] . "</td></tr>\n";
echo "<tr bgcolor=\"#F1F1F1\"><td>Manufacturer: </td><td>" . $myrow["system_vendor"] . "</td></tr>\n";
echo "<tr><td>Operating System: </td><td>" . $myrow["system_os_name"] . "</td></tr>\n";
echo "<tr bgcolor=\"#F1F1F1\"><td>Build Number / Service Pack: </td><td>" . $myrow["system_build_number"] . " / " . $myrow["system_service_pack"] . "</td></tr>\n";
echo "<tr><td>System UUID: </td><td>" . $myrow["system_uuid"] . " </td></tr>\n";
echo "<tr bgcolor=\"#F1F1F1\"><td>Windows Installed On: </td><td>" . $myrow["date_system_install"] . "</td></tr>\n";
echo "<tr><td>IP Address / Subnet: </td><td>" . ip_trans($ip) . " / " . ip_trans($subnet) . "</td></tr>\n";
echo "<tr bgcolor=\"#F1F1F1\"><td>DHCP Enabled / DCHP Server: </td><td>" . $dhcp_enabled . " / " . $dhcp_server . "</td></tr>\n";
echo "<tr><td>Date First Audited: </td><td>" . return_date_time($myrow["system_first_timestamp"]) . " </td></tr>\n";
echo "<tr bgcolor=\"#F1F1F1\"><td>Date Last Audited: </td><td>" . return_date_time($timestamp) . " </td></tr>\n";
echo "<tr><td>System Memory: </td><td>" . $myrow["system_memory"] . " MB</td></tr>\n";
} while ($myrow = mysql_fetch_array($result));
} else {
}
$bgcolor = "#FFFFFF";
$SQL = "SELECT * FROM hard_drive WHERE hard_drive_uuid = '{$pc}' AND hard_drive_timestamp = '{$timestamp}' ORDER BY hard_drive_index";
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\"><td>Hard Drive Size: </td><td>" . number_format($myrow["hard_drive_size"]) . " MB</td></tr>\n";
$result = mysql_query($query) or die("Query failed at delete stage. system_man");
$query = "DELETE FROM system_security WHERE ss_uuid = '" . $id . "'";
$result = mysql_query($query) or die("Query failed at delete stage. system_security");
$query = "DELETE FROM tape_drive WHERE tape_drive_uuid = '" . $id . "'";
$result = mysql_query($query) or die("Query failed at delete stage. tape_drive");
$query = "DELETE FROM usb WHERE usb_uuid = '" . $id . "'";
$result = mysql_query($query) or die("Query failed at delete stage. usb");
$query = "DELETE FROM users WHERE users_uuid = '" . $id . "'";
$result = mysql_query($query) or die("Query failed at delete stage. users");
$query = "DELETE FROM video WHERE video_uuid = '" . $id . "'";
$result = mysql_query($query) or die("Query failed at delete stage. video");
$query = "DELETE FROM other WHERE other_linked_pc = '" . $id . "'";
$result = mysql_query($query) or die("Query failed at delete stage. other");
}
}
$sql = "SELECT system_uuid, net_ip_address, system_name, net_domain, system_os_name, system_system_type, system_timestamp FROM system ORDER BY system_name ";
$result = mysql_query($sql, $db);
$bgcolor = "#FFFFFF";
echo "<td valign=\"top\">\r\n <div class=\"main_each\">";
if ($myrow = mysql_fetch_array($result)) {
echo "<form name=\"DeleteList\" id=\"DeleteList\" method=\"post\" action=\"" . $_SERVER["PHP_SELF"] . "\" >\r\n \r\n <script language=\"JavaScript\" TYPE=\"text/javascript\">\r\n function CheckUncheckAll(form){\r\n if(!form)\r\n return;\r\n var objElements = form.elements;\r\n if(!objElements)\r\n return;\r\n var countElements = objElements.length;\r\n if(!countElements)\r\n return;\r\n else\r\n for (var i = 1; i < countElements; i++){ \r\n eval(\"objElements[\" + i + \"].checked = objElements[1].checked\"); \r\n }\r\n }\r\n </script>\r\n \r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n <tr>\r\n <td class=\"contenthead\">" . __("Delete Systems") . "<br /> </td>\r\n </tr>\r\n </table>\r\n \r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n <tr>\r\n <td width=\"30%\"><input type=\"submit\" name=\"Perform\" id=\"Perform\" value=\"Delete selected systems\" onclick=\"return confirm('Do you really want to DELETE all selected Systems?')\"></td>\r\n <td width=\"70%\"><input type=\"checkbox\" name=\"SetUnset\" id=\"SetUnset\" onClick=\"CheckUncheckAll(this.form);\" />Check/Uncheck all<br /></td> \r\n </tr>\r\n </table>\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n <tr> </tr>\r\n <tr>\r\n <td></td>\r\n <td class=\"contentsubtitle\">" . __("IP Address") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Hostname") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Domain") . "</td>\r\n <td class=\"contentsubtitle\">" . __("OS") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Type") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Date Audited") . "</td>\r\n </tr>\n";
do {
$bgcolor = change_row_color($bgcolor, $bg1, $bg2);
echo "<tr style=\"bgcolor:" . $bgcolor . ";\">\r\n <td width=\"5%\"><input type=\"checkbox\" name=" . $myrow["system_uuid"] . " id=" . $myrow["system_uuid"] . " value=" . $myrow["system_uuid"] . "></td>\r\n <td><a href=\"system.php?pc=" . $myrow["system_uuid"] . "&view=summary\">" . ip_trans($myrow["net_ip_address"]) . "</a></td>\r\n <td><a href=\"system.php?pc=" . $myrow["system_uuid"] . "&view=summary\">" . $myrow["system_name"] . "</a></td>\r\n <td>" . $myrow["net_domain"] . "</td>\r\n <td>" . determine_os($myrow["system_os_name"]) . "</td>\r\n <td>" . determine_img($myrow["system_os_name"], $myrow["system_system_type"]) . "</td>\r\n <td>" . return_date_time($myrow["system_timestamp"]) . "</td>\r\n </tr>\n";
} while ($myrow = mysql_fetch_array($result));
echo " </table>\r\n </form>";
} else {
echo "<p class=\"content\">No Systems in database.</p>\n";
}
echo "</div>\n";
echo "</td>\n";
function GetSystemsNotAuditedData($id)
{
global $db, $days_systems_not_audited;
$tr_class = 'npb_highlight_row';
$sql = "SELECT system_name, net_ip_address, net_domain, system_uuid, system_timestamp,\r\n\tIFNULL(ldap_computer_status, 'deleted') as ldap_status, ldap_connections_name\r\n\tFROM system\r\n\tLEFT JOIN (\r\n\t\t(SELECT ldap_computers_cn, 'active' as ldap_computer_status, ldap_connections_name, ldap_connections_fqdn\r\n\t\tFROM ldap_computers\r\n\t\tLEFT JOIN ldap_paths ON ldap_computers.ldap_computers_path_id=ldap_paths.ldap_paths_id\r\n\t\tLEFT JOIN ldap_connections ON ldap_paths.ldap_paths_connection_id=ldap_connections.ldap_connections_id\r\n\t\tWHERE ldap_computers_timestamp=ldap_paths_timestamp)\r\n\r\n\t\tUNION\r\n\r\n\t\t(SELECT ldap_computers_cn, 'deleted' as ldap_computer_status, ldap_connections_name, ldap_connections_fqdn\r\n\t\tFROM ldap_computers\r\n\t\tLEFT JOIN ldap_paths ON ldap_computers.ldap_computers_path_id=ldap_paths.ldap_paths_id\r\n\t\tLEFT JOIN ldap_connections ON ldap_paths.ldap_paths_connection_id=ldap_connections.ldap_connections_id\r\n\t\tWHERE ldap_computers_timestamp<>ldap_paths_timestamp)\r\n\t) AS U\r\n\tON system.system_name = U.ldap_computers_cn\r\n\tWHERE system_timestamp < '" . adjustdate(0, 0, -$days_systems_not_audited) . "000000'\r\n\tAND (ldap_connections_fqdn=net_domain OR ldap_connections_name=net_domain OR net_domain IS NULL\r\n\tOR ldap_connections_name IS NULL OR ldap_connections_fqdn IS NULL) ORDER BY system_name";
//echo $sql;
$result = mysql_query($sql, $db) or die(mysql_error());
$count = mysql_numrows($result);
echo "<div class='npb_content_data' id='" . $id . "' style='display: none;'>";
if ($myrow = mysql_fetch_array($result)) {
echo "<table>";
echo " <tr>";
echo "\t\t<th>" . __("IP Address") . "</td>";
echo " \t<th>" . __("Hostname") . "</td>";
echo " \t<th>" . __("Date Audited") . "</td>";
echo " \t<th>" . __("LDAP Status") . "</td>";
echo "\t</tr>";
do {
echo "<tr class='" . alternate_tr_class($tr_class) . "'>";
echo "\t<td>" . ip_trans($myrow["net_ip_address"]) . "</td>";
echo "\t<td><a href=\"system.php?pc=" . $myrow["system_uuid"] . "&view=summary\">" . $myrow["system_name"] . "</a></td>";
echo "\t<td>" . return_date_time($myrow["system_timestamp"]) . "</td>";
echo "\t<td><img src='../images/computer_" . $myrow['ldap_status'] . ".gif'></td>";
echo "</tr>";
} while ($myrow = mysql_fetch_array($result));
}
echo "</table>";
echo "</div>";
echo "<p class='npb_section_summary'>" . __("Systems") . ": " . $count . "</p>";
return;
}
?>
</td></tr>
<tr><td>IP Address / Subnet: </td><td><?php
echo $myrow["net_ip_address"] . " / " . $subnet;
?>
</td></tr>
<tr><td>DHCP Enabled / DCHP Server: </td><td><?php
echo $dhcp_enabled . " / " . $dhcp_server;
?>
</td></tr>
<tr><td>System Memory: </td><td><?php
echo $myrow["system_memory"];
?>
MB</td></tr>
<tr><td>Date Audited: </td><td><?php
echo return_date_time($first_audited);
?>
</td></tr>
<?php
} while ($myrow = mysql_fetch_array($result));
} else {
}
$SQL = "SELECT * FROM hard_drive WHERE hard_drive_uuid = '{$pc}' AND hard_drive_timestamp = '{$timestamp}' ORDER BY hard_drive_index";
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
do {
?>
<tr><td>Hard Drive Size: </td><td><?php
echo $myrow["hard_drive_size"];
?>
Gb</td></tr>
echo "<tr>";
echo "<td align=\"left\" class=\"contenthead\">System Audits performed on " . $name . "<br /> </td>";
echo "</tr>";
if ($sub == "su" or $sub == "all") {
$opt_count = 0;
$SQL = "SELECT * FROM system_audits WHERE system_audits_uuid = '{$pc}'";
//echo $SQL;
$result = mysql_query($SQL, $db);
echo "<tr><td class=\"contenthead\"><img src=\"images/inv_summary{$pic_style}.png\" width=\"64\" height=\"64\" alt=\"\" />Audits</td></tr>\n";
echo "<tr><td>Timestamp</td><td>Performed By</td></tr>\n";
if ($myrow = mysql_fetch_array($result)) {
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"{$bgcolor}\"><td>" . return_date_time($myrow["system_audits_timestamp"]) . "</td><td>" . $myrow["system_audits_username"] . "</td></tr>\n";
} while ($myrow = mysql_fetch_array($result));
} else {
}
} else {
}
echo "</table>";
?>
</div>
</div>
</body>
</html>
<?php
include "include_png_replace.php";
