Open-AudIT https://www.open-audit.org/phpBB3/ |
|
Sorting on mainpage (system discovered, systems not audited) https://www.open-audit.org/phpBB3/viewtopic.php?f=9&t=1298 |
Page 1 of 1 |
Author: | bofh [ Wed Aug 23, 2006 12:31 am ] |
Post subject: | Sorting on mainpage (system discovered, systems not audited) |
Hi, Isn't it more logical to sort the systems discovered by date instead of name ? order by system_first_timestamp instead of system_name (index.php line 96) [code] if ($show_system_discovered == "y") { $sql = "SELECT system_name, net_ip_address, system_uuid, system_first_timestamp FROM system "; $sql .= "WHERE system_first_timestamp > '" . adjustdate(0,0,-$system_detected) . "000000' ORDER BY system_first_timestamp";[/code] and line 146 [code] if ($show_systems_not_audited == "y") { $sql = "SELECT system_name, net_ip_address, system_uuid, system_timestamp FROM system WHERE "; $sql .= "system_timestamp < '" . adjustdate(0,0,-$days_systems_not_audited) . "000000' ORDER BY system_timestamp"; [/code] |
Page 1 of 1 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |