BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_HOST_CPU - Match CPU information table

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
OPERATINGSYSTEM_ID number 0  √  null Host Id/Operating System id
IS_VIRTUAL number 0  √  null Is this Virtual m/c?
DISC_MANUFACTURER nvarchar2 255  √  null Discovered manufacturer for this CPU
DISC_CPU_MODEL nvarchar2 255  √  null Discovered CPU Model for this CPU
DISC_SPEED_MHZ number 0  √  null Discovered CPU Speed for this CPU
DISC_NUM_OF_PHYSICAL_CPUS number 0  √  null Discovered no. of physical CPUs
DISC_NUM_OF_LOGICAL_CPUS number 0  √  null Discovered no. of logical CPUs
DISC_NUM_OF_SOCKETS number 0  √  null Discovered no. of sockets for this CPU
CAT_CPU_MANUFACTURER varchar2 255  √  null Catalog CPU Manufacturer
CAT_CPU_MODEL varchar2 255  √  null Catalog CPU Model
CAT_CLOCKRATE_MHZ number 0  √  null Catalog CPU Clock rate
CAT_CORES_PER_CPU number 0  √  null Catalog cores per CPU
CAT_THREADS_PER_CORE number 0  √  null Catalog Threads per CPU
CAT_ISHYPERTHREADCAPABLE varchar2 10  √  null Is hyperthread capable?
CAT_ISABITMODE number 0  √  null Catalog IS Bit mode
CAT_HW_CPUMAX number 0  √  null Catalog CPU Max
CALC_NUM_OF_PHYSICAL_CPUS number 0  √  null Calculated no. of physical CPUs
CALC_NUM_OF_LOGICAL_CPUS number 0  √  null Calculated no. of logical CPUs
CALC_NUM_OF_CORES number 0  √  null Calculated no. of cores
CALC_ISHYPERTHREADENABLE varchar2 10  √  null Calculated value for ISHYPERTHREADENABLE
CAT_HW_MANUFACTURER_ID number 18  √  null Catalog manufacturer Id
CAT_HW_PRODUCT_ID number 18  √  null Catalog HW Product Id
CAT_HW_MODEL_ID number 18  √  null Catalog Hw Model Id
CAT_CPU_MANUFACTURER_ID number 18  √  null Catalog CPU manufacturer Id
CAT_CPU_MODEL_ID number 18  √  null Catalog CPU model Id
TASK_ID number 18  √  null Task ID for this row
INVENTORY_ID number 18  √  null Inventory ID for this row
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
INVENTORY_ID + TASK_ID + OPERATINGSYSTEM_ID + CAT_CPU_MODEL_ID Performance Asc/Asc/Asc/Asc MATCH_HOST_CPU_IDX
Confidential and Proprietary to BDNA