BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_HOST_HW_IBM_PVU - IBM/PVU information matched

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
HOST_ID number 0  √  null Host ID for this hardware product
HOSTNAME nvarchar2 1024  √  null Hostname for this hardware product
SERIALNUMBER nvarchar2 256  √  null Serial number for this hardware product
CAT_MANUFACTURER_ID number 18  √  null Catalog manufacturer id for this hardware product
CAT_MANUFACTURER varchar2 2000  √  null Catalog manufacturer name for this hardware product (e.g., Hewlett-Packard Company)
CAT_HW_PRODUCT_ID number 18  √  null Catalog product ID for this hardware product
CAT_HW_PRODUCT varchar2 255  √  null Catalog product name for this hardware product
CAT_HW_MODEL_ID number 18  √  null Catalog model ID for this hardware product
CAT_HW_MODEL varchar2 2000  √  null Catalog model name for this hardware product (e.g., 397307-xx1)
CAT_CPU_MANUFACTURER_ID number 18  √  null Catalog CPU manufacturer ID for this CPU
CAT_CPU_MANUFACTURER varchar2 255  √  null Catalogo CPU manufacturer
CAT_CPU_MODEL_ID number 18  √  null Catalog CPU ID for this CPU
CAT_CPU varchar2 255  √  null Catalog CPU name for this CPU
CAT_CORES_PER_CHIP number 0  √  null Catalog number of cores per chip for this CPU
CAT_MAX_SOCKET varchar2 2000  √  null Catalog max number of sockets per m/c (e.g., All, 1, 2, 3, 4, >4)
CAT_IBM_PVU_PER_CORE float 126  √  null Catalog IBM PVU per core for this CPU
CAT_TAXONOMY_CATEGORY1 varchar2 256  √  null Taxonomy category 1 from the Catalog (e.g., Computers)
CAT_TAXONOMY_CATEGORY2 varchar2 256  √  null Taxonomy category 2 from the Catalog (e.g., Computers: Servers, Desktops, Notebooks)
CAT_TAXONOMY2012_ID number 18  √  null Taxonomy Id
NUMCPUS number 0  √  null Number of CPUs
NUMCORES number 0  √  null Number of cores for this CPU
IBM_TOTAL_PVU float 126  √  null Total PVU (Processor Value Unit)
VIRTUAL number 0  √  null Is this hardware virtual?
TASK_ID number 18  √  null Task ID for this row
INVENTORY_ID number 18  √  null Inventory ID for this row
DATASRC varchar2 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 Anomalies
INVENTORY_ID + TASK_ID + HOST_ID Primary key Asc/Asc/Asc PK_MATCH_HOST_HW_IBM_PVU These unique columns are also nullable
Confidential and Proprietary to BDNA