BDNA Discover Publish version 7.7.1 with 201612 Sequence
BDNA_OTHER_NETEQP - Other Network Equipment

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
OPERATINGSYSTEM_LABEL varchar2 256  √  null Hostname
HOSTNAME varchar2 256  √  null DNS Host Name
OSCOMPUTERNAME varchar2 256  √  null OS Computer Name
OSNAME varchar2 256  √  null Operating System Name
MANUFACTURER varchar2 256  √  null OS Manufacturer
OPERATINGSYSTEM_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNAOTHERNETEQP_OST R
OS Type
VERSION varchar2 256  √  null OS Version
FREEMEMORY number 22  √  null Free Memory
TOTALMEMORY number 22  √  null Total Memory
TOTMEMBUCKET varchar2 22  √  null Total Memory Bucket
DESCRIPTION varchar2 256  √  null Description
HARDWARE varchar2 256  √  null Machine (Hardware) Type
UPTIME number 22  √  null Up Time
CHASSISTYPE varchar2 256  √  null Chassis Type
NUMCPUS number 22  √  null Number of CPUs
SERIALNUMBER varchar2 256  √  null Serial Number
NUMINTERFACES number 22  √  null Number of Interfaces
LEVEL2 char 1  √  null Level 2?
OPERATINGSYSTEM_ID number 22
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNAOTHERNETEQP R
Operating Systems Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAOTHERNETEQP1_INVENTORY_ID R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNAOTHERNETEQP R
Inventory Id

Analyzed at Fri Oct 21 21:10 PDT 2016

Indexes:
Column(s) Type Sort Constraint Name
INVENTORY_ID + OPERATINGSYSTEM_ID Primary key Asc/Asc PK_BDNA_OTHER_NETEQP

Close relationships  within of separation:
Confidential and Proprietary to BDNA