BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_MSSQL_INSTALLS - Microsoft SQL Server Installations

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
MSSQLSERVERINSTALLATION_LABEL varchar2 256  √  null Installation Label
INSTANCENAME varchar2 256  √  null Instance Name
SERVERNAME varchar2 256  √  null Server Name
VERSION varchar2 256  √  null MSSQL Version
INSTALLDIRECTORY varchar2 256  √  null Installation Directory
LOGINMODE varchar2 256  √  null Login Mode
NAMEDPIPE varchar2 256  √  null Named Pipe
PROTOCOLS varchar2 256  √  null Protocol(s)
MSSQLSERVERINSTALLATION_ID number 22
BDNA_INV_CATALOG_MAP.INV_ASSET_ID FKM1_BDNAMSSQLINSTAL R
Microsoft SQL Server Installation Id
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNAMSSQLINSTAL R
Operating Systems Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAMSSQLINSTALLS_INVENTORY_ID R
BDNA_INV_CATALOG_MAP.INVENTORY_ID FKM1_BDNAMSSQLINSTAL R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNAMSSQLINSTAL R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA