Show Client Name based off MAC Address

The following SQL query displays client name based on a specific MAC address. Replace the MAC address in the where clause. /* Get Client based off MAC Address */  select S.Name0, MAC.MAC_Addresses0 from v_R_System S  join v_RA_System_MACAddresses MAC on S.ResourceID=MAC.ResourceID  where MAC.MAC_Addresses0 = ‘1A:1B:1C:1D:1E:1F’