2.9 NC_CPU Table

The NC_CPU table contains CPU inventory data.

Column

Key

Type

Null

Description

ComponentOID

PK, FK

binary(16)

No

An internal ID number used as a primary key.

Speed

Float

The CPU speed in MHz.

VendorIdentifier

nvarchar(12)

The manufacturer of the CPU.

CPUIDType

smallint

The CPU type.

CPUIDFamily

smallint

The CPU family.

CPUIDModel

smallint

The CPU model.

CPUIDStepping

smallint

The CPU stepping result.

IsMMX

smallint

No

True(1) indicates if the MMX flag features flags; else 0.

L1CacheSize

smallint

The size of the L1 cache.

Is64Bit

 

tinyint

 

1 if a 64-bit processor, else 0

CoreCount

 

tinyint

 

Number of cores in the CPU count, initially 1

IsHyperThreaded

 

tinyint

 

1 if the processor is hyperthreaded, else 0

NOTE:The ComponentOID foreign key references the ComponentOID primary key column of the NC_CPUComp table.