BDNA Data Platform 5.4 July 2017 (SQL Server)
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 numeric 20 Unique CPU ID
INVENTORY_ID numeric 20 Inventory ID for this row
TASK_ID numeric 20 Task ID for this row
OPERATINGSYSTEM_ID numeric 20  √  null Operating System ID for this console
CPU_LABEL nvarchar 512  √  null CPU Label (e.g., CPU0, CPU2, CPU3)
MODEL nvarchar 512  √  null CPU Model (e.g., Genuine Intel(R) CPU T2500 @ 2.00GHz)
SOCKETDESIGNATION nvarchar 512  √  null Socket designation (e.g., Microprocessor, Socket M2, Proc 3)
MANUFACTURER nvarchar 512  √  null Manufacturer for this CPU (e.g., Genuine Intel, Authentic AMD)
SPEED float 8  √  null CPU speed
MAXSPEED float 8  √  null Maximum CPU speed
BITS float 8  √  null CPU bits
ISA nvarchar 8000  √  null CPU ISA (instruction set architecture)
CORES float 8  √  null Number of CPU cores
THREADS float 8  √  null Number of CPU threads
DATASRC nvarchar 50  √  null Data Source for this row (e.g., SCCM, ADDM)
CAT_CPU_MODEL_ID numeric 20  √  null CPU ID from the catalog

Analyzed at Thu Jul 20 12:14 PDT 2017

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