Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Thu Nov 22, 2018 4:05 am

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
PostPosted: Fri Jul 30, 2010 1:36 am 
Offline
Helper

Joined: Thu Apr 15, 2010 12:28 am
Posts: 83
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
+?>


Top
 Profile  
Reply with quote  
PostPosted: Mon Feb 27, 2012 11:39 pm 
Offline
Newbie

Joined: Mon Feb 13, 2012 10:21 pm
Posts: 11
Hi,

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


Top
 Profile  
Reply with quote  
PostPosted: Tue Feb 28, 2012 2:38 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
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".


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group