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 Tue Mar 19, 2024 2:35 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",
[/code]

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 437 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

[size=85]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[/size]


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 2 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