select 
    CS.Name0,
    NAC.ServiceName0,
    NAC.MACAddress0
from 
    dbo.v_GS_COMPUTER_SYSTEM CS
    Join dbo.v_GS_NETWORK_ADAPTER_CONFIGURATION NAC on CS.ResourceID = NAC.ResourceID