#!/bin/sh -x

# remove duplicate addresses from the database

nawk '{
    if ($1 ~ /^8:0:69:[0-9a-f:]*=/ && $2 != "engr" && $2 != "xxxxxx") {
	split($1, mac_type, "=")
	if (macs[$2] != "") {
	    n = ++dups[$2]
	    sub("\tby","-dup" n "\tby")
	    numdups = numdups + 1
	} else {
	    macs[$2] = mac_type[1]
	}
    }
    print $0
}'
