SELECT
RV.Netbios_Name0,
BIOS.SerialNumber0,
ES.SerialNumber0
FROM
dbo.v_R_System_Valid RV
join dbo.v_GS_PC_BIOS BIOS on RV.ResourceID = BIOS.ResourceID
join dbo.v_GS_SYSTEM_ENCLOSURE ES on RV.ResourceID = ES.ResourceID
WHERE
BIOS.SerialNumber0 !=ES.SerialNumber0