Open-AudIT
https://www.open-audit.org/phpBB3/

PATCH: Systems Not Audited in the last 3 Days sorted by time
https://www.open-audit.org/phpBB3/viewtopic.php?f=9&t=3738
Page 1 of 1

Author:  jonbendtsen [ Fri Jul 30, 2010 1:36 am ]
Post subject:  PATCH: Systems Not Audited in the last 3 Days sorted by time

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
+?>

Author:  nithi123 [ Mon Feb 27, 2012 11:39 pm ]
Post subject:  Re: PATCH: Systems Not Audited in the last 3 Days sorted by

Hi,

Can you tell me where to exactly should i use the patch.

Author:  jpa [ Tue Feb 28, 2012 2:38 am ]
Post subject:  Re: PATCH: Systems Not Audited in the last 3 Days sorted by

In non-patch speak it says:

Open the index_data.php file from the openaudit htdocs directory wherever you have it.
Go to line number 328.
At the end of the line change "ORDER BY system_name" to ORDER BY system_timestamp".

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/