Duplicate MAC Address LocatorĀ for Oracle and MySQL
Service Desk Cabling
SELECT COUNT(MAC_ADDRESS) CNT, MAC_ADDRESS FROM EQUIPMENT GROUP BY MAC_ADDRESS HAVING COUNT(MAC_ADDRESS) > 1
SELECT COUNT(MAC_ADDRESS) CNT, MAC_ADDRESS FROM EQUIPMENT GROUP BY MAC_ADDRESS HAVING COUNT(MAC_ADDRESS) > 1