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