Open-AudIT

What's on your network?
It is currently Wed Apr 25, 2018 10:30 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
PostPosted: Wed Sep 30, 2009 5:19 pm 
Offline
Newbie

Joined: Wed Sep 05, 2007 1:20 am
Posts: 23
Hi,

Open-Audit displays zero sized hard disks like all the SD, CF, MMC etc card readers under the harddisk statistics. These are of no value and skew the stats.

Here's a fix:
Code:
$ svn diff list_viewdef_statistic_harddrive.php
Index: list_viewdef_statistic_harddrive.php
===================================================================
--- list_viewdef_statistic_harddrive.php        (revision 1186)
+++ list_viewdef_statistic_harddrive.php        (working copy)
@@ -9,14 +9,16 @@
                                        SELECT count(*)
                                        FROM hard_drive, system WHERE
                                            system_uuid=hard_drive_uuid AND
-                                           system_timestamp=hard_drive_timestamp
+                                           system_timestamp=hard_drive_timestamp AND
+                                           hard_drive_size!=0
                                        )
                                  * COUNT(*)
                                ,$round_to_decimal_places) AS percentage
                            FROM hard_drive, system
                            WHERE
                                system_uuid=hard_drive_uuid AND
-                               system_timestamp=hard_drive_timestamp
+                               system_timestamp=hard_drive_timestamp AND
+                               hard_drive_size!=0
                            GROUP BY hard_drive_size
                            ",
                    "sort"=>"count_item",


Attached is the modified file. Please apply to svn trunk.


Attachments:
File comment: do not show zero sized disks
list_viewdef_statistic_harddrive.php.zip [706 Bytes]
Downloaded 156 times
Top
 Profile  
Reply with quote  
PostPosted: Wed Sep 30, 2009 9:21 pm 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
Added at SVN 1187.
Thanks.

_________________
Andrew

OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory


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.  [ 2 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 1 guest


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