BDNA Discover Publish version 7.7.2 with 201708
BDNA_MSSQL_INSTANCES - Microsoft SQL Server Instances

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
MSSQLSERVERINSTANCE_LABEL varchar2 256  √  null Instance Label
INSTANCENAME varchar2 256  √  null Instance Name
SERVERNAME varchar2 256  √  null Server Name
VERSION varchar2 256  √  null MSSQL Version
INSTANCEHOME varchar2 256  √  null Instance Home
CLUSTERNAME varchar2 4000  √  null Cluster Name
ISCLUSTERED varchar2 256  √  null Is Clustered?
NAMEDPIPE varchar2 256  √  null Named Pipe
PORT varchar2 256  √  null Port
STARTMODE varchar2 256  √  null Start Mode
STATE varchar2 256  √  null State
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNAMSSQLINSTAN R
Operating Systems Id
MSSQLSERVERINSTANCE_ID number 22
BDNA_MSSQL_DBS.MSSQLSERVERINSTANCE_ID FKM1_BDNA_MSSQL_DBS R
BDNA_INV_CATALOG_MAP.INV_ASSET_ID FKM1_BDNAMSSQLINSTAN R
Microsoft SQL Server Instance Id
INVENTORY_ID number 22 -1
BDNA_MSSQL_DBS.INVENTORY_ID FKM1_BDNA_MSSQL_DBS R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAMSSQLINSTANCE_INVENTORY_ID R
BDNA_INV_CATALOG_MAP.INVENTORY_ID FKM1_BDNAMSSQLINSTAN R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNAMSSQLINSTAN R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA