vvProAssetDetails

Lists information about a vPro enabled machine, including manufacturing details about the motherboard.

Column Name

Type

Purpose

agentGuid

numeric(26,0), null

Unique 26 digit random number identifying this agent. Master record stored in machNameTab.

displayName

varchar(201), null

If the vPro machine has an agent on it then the display name is the machine.GroupId of a normal agent listing. Otherwise it is blank.

hostName

varchar(255), null

name of the machine on the LAN

computerName

varchar(255), null

holds the computer name found in the OS

assetId

varchar(50), not null

the asset Id is part of the basic hardware information

computerModel

varchar(65), null

Model designation of the computer

computerManufacturer

varchar(65), null

Manufacturer of the computer

computerVersion

varchar(65), null

Version number of the computer

computerSerialNumber

varchar(65), null

Serial number of the computer

mbManufacturer

varchar(65), null

Motherboard manufacturer

mbProductName

varchar(65), null

Product name of the motherboard

mbVersion

varchar(65), null

Version number of the motherboard

mbSerialNumber

varchar(65), null

Serial number of the motherboard

mbAssetTag

varchar(65), null

Asset tag for the motherboard

mbReplaceable

tinyint(3), null

True or false if the motherboard is replaceable

biosVendor

varchar(65), null

Vendor for the BIOS

biosVersion

varchar(65), null

Version number of the BIOS

biosReleaseDate

datetime(3), null

BIOS release date

biosSupportedFunctions

varchar(1000), null

List of BIOS supported features

ipAddress

varchar(19), null

ipAddress of the vPro machine used by power management and remote ISO boot