Find computers by BIOS serial number

SELECT
    CS.Name0,
    CS.UserName0,
    BIOS.Manufacturer0,
    BIOS.SerialNumber0
FROM
    dbo.v_GS_COMPUTER_SYSTEM CS,
    dbo.v_GS_PC_BIOS BIOS
WHERE
    CS.ResourceID = BIOS.ResourceID
    AND BIOS.SerialNumber0=<Enter Serial Number here>

Leave a Reply

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