BDNA Data Platform 5.4 July 2017 (SQL Server)
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 numeric 20 Host ID for this hardware product
HOSTNAME varchar 1024  √  null Hostname for this hardware product
SERIALNUMBER varchar 256  √  null Serial number for this hardware product
CAT_MANUFACTURER_ID numeric 20  √  null Catalog manufacturer id for this hardware product
CAT_MANUFACTURER varchar 2000  √  null Catalog manufacturer name for this hardware product (e.g., Hewlett-Packard Company)
CAT_HW_PRODUCT_ID numeric 20  √  null Catalog product ID for this hardware product
CAT_HW_PRODUCT varchar 255  √  null Catalog product name for this hardware product
CAT_HW_MODEL_ID numeric 20  √  null Catalog model ID for this hardware product
CAT_HW_MODEL varchar 2000  √  null Catalog model name for this hardware product (e.g., 397307-xx1)
CAT_CPU_MANUFACTURER_ID numeric 20  √  null Catalog CPU manufacturer ID for this CPU
CAT_CPU_MANUFACTURER varchar 255  √  null Catalogo CPU manufacturer
CAT_CPU_MODEL_ID numeric 20  √  null Catalog CPU ID for this CPU
CAT_CPU varchar 255  √  null Catalog CPU name for this CPU
CAT_CORES_PER_CHIP numeric 20  √  null Catalog number of cores per chip for this CPU
CAT_MAX_SOCKET varchar 2000  √  null Catalog max number of sockets per m/c (e.g., All, 1, 2, 3, 4, >4)
CAT_IBM_PVU_PER_CORE float 8  √  null Catalog IBM PVU per core for this CPU
CAT_TAXONOMY_CATEGORY1 varchar 256  √  null Taxonomy category 1 from the Catalog (e.g., Computers)
CAT_TAXONOMY_CATEGORY2 varchar 256  √  null Taxonomy category 2 from the Catalog (e.g., Computers: Servers, Desktops, Notebooks)
CAT_TAXONOMY2012_ID numeric 20  √  null Taxonomy Id
NUMCPUS numeric 20  √  null Number of CPUs
NUMCORES numeric 20  √  null Number of cores for this CPU
IBM_TOTAL_PVU float 8  √  null Total PVU (Processor Value Unit)
VIRTUAL numeric 20  √  null Is this hardware virtual?
TASK_ID numeric 20 Task ID for this row
INVENTORY_ID numeric 20 Inventory ID for this row
DATASRC varchar 25  √  null Data Source for this row (e.g., SCCM, ADDM)

Analyzed at Thu Jul 20 12:14 PDT 2017

Confidential and Proprietary to BDNA