SCCM how to find a MAC address

Many times you need to find a computer with a specific mac address.

For example today in a customer site I was prepared to reimage a computer with no OS. I didn’t se my TS for unknow computers available, that means this computer was already in SCCM but without that name or OS where to see the computer name, MAC address it was the easiest way to find the computer in SCCM and delete him from DB. So I have made a simple SCCM query to prompt MAC  address and show the computer, the MAC address is in the form of ZZ:ZZ:ZZ:ZZ:ZZ:ZZ


The query is:

select distinct SMS_R_System.Name, SMS_R_System.MACAddresses from  SMS_R_System where SMS_R_System.MACAddresses = ##PRM:SMS_R_System.MACAddresses## order by SMS_R_System.MACAddresses


SCCM MAC address query

SCCM MAC address result

Easy, no, happy SCCM-ing