Find Machine by MAC Address in SCCM

When working with System Center Configuration Manager (SCCM), administrators often need to find machines based on their Media Access Control (MAC) address. This article will walk you through the process of finding a machine by its MAC address in SCCM.

One common method for finding machines by MAC address is using SQL queries directly on the SCCM database. However, SCCM also offers reporting and query features under Monitoring that can be used to achieve this task more easily.

To start, we'll need to use the following query:

`SELECT A.Name0, c.IPAddress0, D.IP_Subnets0

FROM v_RA_System_IPSubnets D

INNER JOIN v_GS_NETWORK_ADAPTER_CONFIGUR C ON A.ResourceID=C.ResourceID

INNER JOIN v_FullCollectionMembership B on A.ResourceID=B.ResourceID

ORDER BY A.Name0, c.IPAddress0, D.IP_Subnets0

GROUP BY A.Name0, c.IPAddress0, D.IP_Subnets0`

This query will return a list of machines with their corresponding IP addresses. However, this may not be the most user-friendly output, as it shows multiple IP addresses for each machine on separate rows.

For a more concise view, you can use the 'SCCM REPORT TO LIST IP ADDRESSES – FULL VERSION' query:

`ORDER by A.Name0,c.IPAddress0 ,D.IP_Subnets0

GROUP by A.Name0,c.IPAddress0 ,D.IP_Subnets0

INNER Join v_RA_System_IPSubnets D ON A.ResourceID=D.ResourceID

Inner join v_GS_NETWORK_ADAPTER_CONFIGUR C ON A.ResourceID=C.ResourceID

Inner join v_FullCollectionMembership B on A.ResourceID=B.ResourceID`

This query will group the IP addresses by machine, making it easier to view the results.

Alternatively, you can use SCCM Reporting and SCCM Queries under Monitoring to achieve the same result.

In conclusion, finding a machine by its MAC address in SCCM is a straightforward process that can be accomplished using SQL queries or SCCM's reporting features. By following these steps, you'll be able to quickly locate machines based on their MAC addresses and manage your SCCM environment more efficiently.

Find machine by mac address in sccm