BDNA Discover Publish version 7.7.2 with 201708
BDNA_MACOS_SYSPROF_APPS - Mac OS Applications Listed by System Profiler

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
OPERATINGSYSTEM_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNAMACOSSYSPRO_OST R
OS Type
NAME varchar2 256  √  null Application Name
VERSION varchar2 256  √  null Application Version
LOCATION varchar2 256  √  null Application Location
RUNTIMEENVIRONMENT varchar2 256  √  null Runtime Environment
LASTMODIFIED varchar2 256  √  null Last Modified
INFOSTRING varchar2 4000  √  null Info String
NUMCPUS number 22  √  null Number of CPUs
OPERATINGSYSTEM_ID number 22  √  null Operating Systems Id
INSTALLEDAPPLICATION_ID number 22 Installed Application Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAMACOSSYSPROFA_INVENTORY_ID R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA