Table BDNA_PUBLISH.dbo.DISC_CPUS
Has Discovered CPU information

 Generated by
SchemaSpy
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 float 8 Unique CPU Id
INVENTORY_ID float 8
DISC_ALL_OS.INVENTORY_ID FK0_DISC_CPUS R
Inventory Id for this row
TASK_ID float 8
DISC_ALL_OS.TASK_ID FK0_DISC_CPUS R
Task Id for this row
OPERATINGSYSTEM_ID float 8  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_CPUS R
Operating System Id for this console
CPU_LABEL nvarchar 512  √  null CPU Label eg:CPU0,CPU2,CPU3
MODEL nvarchar 512  √  null CPU Model eg: Genuine Intel(R) CPU T2500 @ 2.00GHz
SOCKETDESIGNATION nvarchar 512  √  null Socket designation eg:Microprocessor,Socket M2,Proc 3
MANUFACTURER nvarchar 512  √  null Manufacturer for this CPU eg:GenuineIntel,AuthenticAMD
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 eg: SCCM, ADDM
CAT_CPU_ID float 8  √  null CPU Id from the catalog

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
CPU_ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_DISC_CPUS
INVENTORY_ID + OPERATINGSYSTEM_ID + CAT_CPU_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

Close relationships  within of separation: