Collection For MacAddresses

select 
SMS_R_System.ResourceId, 
SMS_R_System.ResourceType, 
 SMS_R_System.Name, 
SMS_R_System.SMSUniqueIdentifier, 
 SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System where SMS_R_System.MACAddresses = "XX:XX:XX:XX:XX:XX"