2.2 NC_AMTDevice Table

The NC_AMTDevice table contains information about the Intel AMT device.

Column

Key

Type

Null

Description

NetworkDeviceOID

PK, FK

binary(16)

No

Unique identifier for every discovered device.

SystemUUID

binary(16)

No

Unique identifier for the Intel AMT device.

HostName

nvarchar(255)

The hostname of the device.

DomainName

nvarchar(255)

The domain name of the device.

FQDN

 

nvarchar(255)

The fqdn of the device.

ProvisionStatus

nvarchar(255)

The Provisioning Status of the device. For example, Provisioning in progress, Unprovisioning in progress.

ProvisionDateTime

datetime

The date and time when the device is provisioned.

AmtVersionInfo

nvarchar(255)

The AMT version of the device.

PowerState

nvarchar(255)

The Power State of device.

IPAddress

nvarchar(255)

The IP Address of the device.

SubnetMask

nvarchar(255)

The Subnet Mask of device.

DefaultGatewayIP

nvarchar(255)

The Default Gateway of device.

PrimaryDNS

nvarchar(255)

The Primary DNS of device.

SecondaryDNS

nvarchar(255)

The Secondary DNS of device.

ProvisioningState

nvarchar(255)

The Provisioning State of the device. For example, Discovered, Suspended, Provisioned, Unprovisioned.

ProvisioningInterface

nvarchar(255)

The Provisioning Interface of the device, such as TLS PKI.

PkiHash

ntext

The Hash obtained from the device.

ProvisioningServerIP

nvarchar(255)

The Provisioning Server IP.

ProvisioningServerGuid

nvarchar(255)

The Provisioning Server Guid.

ProvisionCredentialGuid

nvarchar(255)

The Credential Vault Guid.

PID

ntext

Not used.

PPS

ntext

Not used.

ProvisioningMode

nvarchar(255)

No

The Provisioning Mode of the device (Enterprise or Small Business)

BiosVersion

nvarchar(255)

The Bios version.

BiosVendor

nvarchar(255)

The Bios vendor.

SystemSerialNumber

nvarchar(255)

The System Serial Number.

BaseBoardSerialNumber

nvarchar(255)

The Base Board Serial Number.