SCCM 2012 WQL Query for MAC Address PromptIf you would like to search for a machine based upon its MAC address, you can use a WQL query to do this. The WQL query that you should use for this is below:
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
If you have any problems with this, please leave a comment below.Labels: Query, SCCM, SQL