Table BDNA_PUBLISH.dbo.DISC_HOSTS
Has Discovered Hosts 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
HOST_ID float 8
DISC_ALL_OS.HOST_ID FK2_DISC_ALL_OS R
DISC_COMPUTERSYSTEM.COMPUTERSYSTEM_ID FK2_DISC_COMPUTERSYSTEM R
MATCH_HOST_SW_PROD.HOST_ID FK8_MATCH_HOST_SW_PROD R
MATCH_HOST_SW_PROD_DET.HOST_ID FK8_MATCH_HOST_SW_PROD_DET R
MATCH_SOFTWARE_METERING.HOST_ID FK6_MATCH_SOFTWARE_METERING R
Host Id
TASK_ID float 8
DISC_ALL_OS.TASK_ID FK2_DISC_ALL_OS R
DISC_COMPUTERSYSTEM.TASK_ID FK2_DISC_COMPUTERSYSTEM R
MATCH_HOST_SW_PROD.TASK_ID FK8_MATCH_HOST_SW_PROD R
MATCH_HOST_SW_PROD_DET.TASK_ID FK8_MATCH_HOST_SW_PROD_DET R
MATCH_SOFTWARE_METERING.TASK_ID FK6_MATCH_SOFTWARE_METERING R
MATCH_TASK_DET.TASK_ID FK0_DISC_HOSTS R
Task Id for this row
INVENTORY_ID float 8
DISC_ALL_OS.INVENTORY_ID FK2_DISC_ALL_OS R
DISC_COMPUTERSYSTEM.INVENTORY_ID FK2_DISC_COMPUTERSYSTEM R
MATCH_HOST_SW_PROD.INVENTORY_ID FK8_MATCH_HOST_SW_PROD R
MATCH_HOST_SW_PROD_DET.INVENTORY_ID FK8_MATCH_HOST_SW_PROD_DET R
MATCH_SOFTWARE_METERING.INVENTORY_ID FK6_MATCH_SOFTWARE_METERING R
MATCH_INVENTORY.INVENTORY_ID FK1_DISC_HOSTS R
Inventory Id for this row
HOSTNAME varchar 1024  √  null Host name
DOMAIN varchar 1024  √  null Domain of the host
ACTIVE varchar 1024  √  null Is host active? 1= yes, 0 = no
OBSOLETE varchar 1024  √  null Is host obsolete? 1= yes, 0= no
DATASRC varchar 25  √  null Data Source for this row eg: SCCM, ADDM

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
HOST_ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_DISC_HOSTS

Close relationships  within of separation: