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>

Published Sunday, September 28, 2008 11:22 AM by Garth
Filed under: , , ,

Comments

# SMS report help | keyongtech@ Sunday, January 18, 2009 11:38 AM

Pingback from  SMS report help | keyongtech

by SMS report help | keyongtech