search cancel

"The specified MACAddress is already present" error when predefining machines does not say what uses the MAC.

book

Article ID: 175109

calendar_today

Updated On:

Products

Deployment Solution

Issue/Introduction

"The specified MACAddress is already present" error when predefining machines does not say what resource has the MAC Address in use

The specified MACAddress is already present.

Resolution

There are 4 tables involved in the MAC Address checks for predefined computers:

  • Inv_AeX_AC_TCPIP
  • Inv_AeX_AC_TCPIPv6
  • Inv_Device_TCPIP
  • Inv_HW_Network_Adapter

To see if any of these contain the MAC Address and to find the Resource GUID for the resource that does, I would use a query for example like this (put yout MAC in the LIKE clause in the end):

SELECT * FROM
(SELECT [_ResourceGuid], [MAC Address], [IP Address], [Host Name], 'Inv_AeX_AC_TCPIP' AS [Table] FROM dbo.Inv_AeX_AC_TCPIP
WHERE ([MAC Address] IS NOT NULL AND [MAC Address] <> '' )
UNION
SELECT [_ResourceGuid], [MAC Address], [IP Address], [Host Name], 'Inv_AeX_AC_TCPIPv6' FROM dbo.Inv_AeX_AC_TCPIPv6
WHERE ([MAC Address] IS NOT NULL AND [MAC Address] <> '' AND [MAC Address] <> '00-00-00-00-00-00-00-E0')
UNION
SELECT [_ResourceGuid], [MAC Address], [IP Address], '', 'Inv_Device_TCPIP' FROM Inv_Device_TCPIP
WHERE ([MAC Address] IS NOT NULL AND [MAC Address] <> '')
UNION
SELECT [_ResourceGuid], REPLACE([Network Address], ':', '-') [MAC Address], '', '', 'Inv_HW_Network_Adapter' FROM dbo.Inv_HW_Network_Adapter
WHERE ([Network Address] IS NOT NULL AND [Network Address] <> '')
) AS M
WHERE M.[MAC Address] LIKE '%the problematic MAC address%'