SELECT
RV.Netbios_Name0,
RV.User_Name0,
BIOS.Manufacturer0,
BIOS.SerialNumber0
FROM
dbo.v_R_System_Valid RV
join dbo.v_GS_PC_BIOS BIOS on RV.ResourceID = BIOS.ResourceID
WHERE
BIOS.SerialNumber0='<Enter Serial Number here>’