This query only needs to be run prior to requesting an upgrade to 2020.3 or newer. It will allow your Organization to locate multiple Equipment that shares a MAC AdressAddress. In 2020.3, a constraint is placed on MAC Address fields being unique across the system.
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
SELECT COUNT( * FROM EQUIPMENT WHERE MAC_ADDRESS) CNT, IN (SELECT MAC_ADDRESS FROM EQUIPMENT E2 GROUP BY E2.MAC_ADDRESS HAVING COUNT(E2.MAC_ADDRESS) > 1) |