SMSUG.ca

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

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





Proud member of the myITforum Network

Support your community. Donate to myITforum

Locations of visitors to this page View Garth Jones's profile on LinkedIn

User Groups

SMS Add-ons

Training
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems