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'