BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_CPUS - CPU information discovered

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
CPU_ID number 0  √  null Unique CPU ID
INVENTORY_ID number 18  √  null
DISC_ALL_OS.INVENTORY_ID FK0_DISC_CPUS R
Inventory ID for this row
TASK_ID number 18  √  null
DISC_ALL_OS.TASK_ID FK0_DISC_CPUS R
Task ID for this row
OPERATINGSYSTEM_ID number 0  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_CPUS R
Operating System ID for this console
CPU_LABEL nvarchar2 256  √  null CPU Label (e.g., CPU0, CPU2, CPU3)
MODEL nvarchar2 256  √  null CPU Model (e.g., Genuine Intel(R) CPU T2500 @ 2.00GHz)
SOCKETDESIGNATION nvarchar2 256  √  null Socket designation (e.g., Microprocessor, Socket M2, Proc 3)
MANUFACTURER nvarchar2 256  √  null Manufacturer for this CPU (e.g., Genuine Intel, Authentic AMD)
SPEED float 126  √  null CPU speed
MAXSPEED float 126  √  null Maximum CPU speed
BITS float 126  √  null CPU bits
ISA nvarchar2 2000  √  null CPU ISA (instruction set architecture)
CORES float 126  √  null Number of CPU cores
THREADS float 126  √  null Number of CPU threads
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
CAT_CPU_MODEL_ID number 18  √  null CPU ID from the catalog

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + CPU_ID Primary key Asc/Asc/Asc PK_DISC_CPUS These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA