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

query help: non-USB storage used per system
https://www.open-audit.org/phpBB3/viewtopic.php?f=10&t=3409
Page 1 of 1

Author:  kli [ Wed Sep 02, 2009 7:50 am ]
Post subject:  query help: non-USB storage used per system

I've been asked to create a report that shows how much non-USB storage is used on each audited system.

The hard drive table only has a size column, there isn't a "space used" column. I planned to calculate the amount of space used from the partition table by subtracting partition_free_space from partition_size.

I created a view that only contains the non-USB hard drives. When I join that view to the partition table with hard_drive_uuid = partition_uuid and partition_disk_index = hard_drive_index, I get multiple results per hard drive for a lot of partitions. I don't think that's correct, and when I sum partition_free_space (and partition_size), I will get several times the numbers I should see. For example, partition 1 has a partition size of 1000. That partition is listed for three different hard drives. If I sum the partition size of the system, I'll get a value of 3000 rather than 1000.

I think the problem is that I cannot get the partitions properly correlated with the hard drives. Is there a way to do this?

Also, while I'm asking for help - is there an entity relationship diagram for the Open-AudIT database? I was unable to find one, and I think it would help me immensely.

I appreciate any advice you can give me about this query. :)

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