Whereas with SQL query, you would need to run the query against the ConfigMgr database every time you need to find the device name from MAC address. That’s because you create the query once, and you can run it whenever required. Out of the above methods, the WQL query method is easy and will save your time. The results are fetched directly from the Configuration Manager database. SQL query should be used to find computers with the duplicate MAC addresses. SQL Query – There are SQL queries available that can tell you the device name when you input MAC address.

WQL Query – You can create a WQL query in SCCM to find the device name using the MAC address.There are different ways to get the MAC address of devices in SCCM: Ways to Find MAC address of Computers in SCCM FYI, SCCM can handle duplicate MAC address with SCCM duplicate hardware identifiers setting. In such situations, you can find out the device name using MAC address with help of a simple query. Whenever there are devices with duplicate mac addresses, the PXE boot will not work fine. The problem is that MAC Addresses are unique identifiers of network interfaces, but when you use the same USB to Ethernet adapter for multiple deployments, that’s where the PXE issues arise. SCCM thinks that it’s the same device and your device doesn’t receive the Task Sequence deployment. Devices such as Surface Pro 3, dell tablets don’t have Ethernet ports, and you have to use a USB to Ethernet adapter for imaging. 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 for dell laptop