PXE Issues with Duplicate MAC Addressesįinding the device name from Mac address is useful during PXE troubleshooting. In this article, we will be using SCCM to query the ConfigMgr database to find clients with duplicate MAC addresses.

When you install SCCM, it comes with default 18 WQL queries that you can use to locate devices in a Configuration Manager hierarchy that matches your query criteria. However, you can create a custom WQL query to find the device name using the Mac address that you input. There is no built-in WQL query present in SCCM to get the device name from the MAC address. It is a 12-digit hexadecimal number mostly represented by Colon-Hexadecimal notation. Thankfully, the query is available, and you just need to know how to create and use it.Ī MAC address is a unique identifier assigned to a network interface controller (NIC).

You can create WQL Query in SCCM to find computer name using MAC Address.įinding the MAC address of a computer in SCCM is easy but if you want to get computer name from MAC address, you will need a custom query for that. This article will explain how to create SCCM MAC address query to get device name from MAC Address.

How to find mac address in sccm 2012