Hi
I found it annoying that Systems Not Audited in the last 3 Days on the frontpage was not sorted by time, so i made this patch that does it. It would be even better if one could click one of the coloumns in the top line IP Address Hostname Date Audited LDAP Status and get it sorted by that order.
[code]Index: index_data.php =================================================================== --- index_data.php (revision 1245) +++ index_data.php (working copy) @@ -325,7 +325,7 @@ ON system.system_name = U.ldap_computers_cn WHERE system_timestamp < '" . adjustdate(0,0,-$days_systems_not_audited) . "000000' AND (ldap_connections_fqdn=net_domain OR ldap_connections_name=net_domain OR net_domain IS NULL - OR ldap_connections_name IS NULL OR ldap_connections_fqdn IS NULL) ORDER BY system_name"; + OR ldap_connections_name IS NULL OR ldap_connections_fqdn IS NULL) ORDER BY system_timestamp"; //echo $sql; @@ -1471,4 +1471,4 @@ return; } -?> \ No newline at end of file +?> [/code]
|