@Duncan There are SQL queries that can list duplicate data in a specific field. Once you have the select statement prepared, you can then put it in parentheses into the WHERE clause for a delete command.
So…
select duplicates from hostMac.mac address; (or whatever it is)
delete from hostMac where (select duplicates from hostMac.mac address);
get it? It’s been a hot second since I’ve used SQL heavily so I don’t quite remember the syntax but I’m sure you can figure it out.
Please post the command you come up with, this is one way you can GIVE BACK to an open source project. 🙂
PLEASE PLEASE export your DB before you delete anything!
FOG Configuration -> Configuration Save -> Export