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

Products

• Deployment Solution

Issue/Introduction

Predefining machines does not say what resource has the MAC Address in use as seen in the following error:

The specified MACAddress is already present.

Environment

Deployment Solution 8.x

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%'