| Open-AudIT https://www.open-audit.org/phpBB3/ |
|
| SVN 760 Duplicate info graphs_disk, network_card and hard_dr https://www.open-audit.org/phpBB3/viewtopic.php?f=8&t=2319 |
Page 1 of 1 |
| Author: | jpmorgan [ Sat Aug 18, 2007 7:07 am ] |
| Post subject: | SVN 760 Duplicate info graphs_disk, network_card and hard_dr |
I'm getting duplicate information in my database. I have duplicate info in graphs_disk, network_card and hard_drive tables. It's most noticeable by looking at the disk bar charts. They get wider ever time I inventory. In addition, each table is disproportionately big. The following query returned multiple duplicates indicated as NumOccurances: [code]SELECT net_mac_address , count(net_mac_address )as NumOccurances FROM network_card GROUP BY net_mac_address HAVING count(net_mac_address )>1 ORDER BY `NumOccurances` ASC[/code] Deleting the system from inventory fixed the duplication of network_card and hard_drive data, but not graphs_disk. Maybe these issues were fixed at some point but not the graphs_disk. Is it ok to just delete the duplicate information in each table, just leaving the one with the latest timestamp? Is anyone else having this problem? |
|
| Page 1 of 1 | All times are UTC + 10 hours |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|