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