Tables
Constraints
Columns
BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_COMPUTERSYSTEM - Computer Systems information discovered
Related columns
Constraints
Comments
Legend
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
COMPUTERSYSTEM_ID
numeric
20
Unique Computer System ID
INVENTORY_ID
numeric
20
Inventory ID for this row
TASK_ID
numeric
20
Task ID for this row
DOMAIN
varchar
1024
√
null
Domain for this Computer System
MANUFACTURER
varchar
1024
√
null
Manufacturer (e.g., Dell Inc., Compaq)
MODEL
varchar
1024
√
null
Manufuacturer (e.g., Latitude D620, ProLiant BL465c G5)
HOSTNAME
varchar
1024
√
null
Hostname for this system
DATASRC
varchar
100
√
null
Data Source for this row (e.g., SCCM, ADDM)
Analyzed at Thu Jul 20 12:14 PDT 2017
Confidential and Proprietary to BDNA