Find all PC where BIOS SerialNumber != Eclosure SerialNumber

SELECT
CS.Name0,
BIOS.SerialNumber0,
ES.SerialNumber0
FROM
v_GS_COMPUTER_SYSTEM CS,
v_GS_PC_BIOS BIOS,
v_GS_SYSTEM_ENCLOSURE ES
WHERE
BIOS.ResourceID = CS.ResourceID
AND ES.ResourceID = CS.ResourceID
AND BIOS.SerialNumber0 !=ES.SerialNumber0

Leave a Reply

Your email address will not be published. Required fields are marked *