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
Easy, no, happy SCCM-ing