SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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 Sep 28 2008, 11:22 AM by Garth
Filed under: , , ,

Comments

 

SMS report help | keyongtech said:

Pingback from  SMS report help | keyongtech

January 18, 2009 11:38 AM

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems