BDNA Discover Publish version 7.7.2 with 201708
BDNA_FP_APPS - Fingerprinted Applications on all OS

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 BDNA_FP_APPS0_OST R
OS Type
OS_EDITION varchar2 256  √  null OS Edition
OS_VERSION varchar2 256  √  null OS Version
PATCHLEVEL1 varchar2 256  √  null OS Patch Level/Service Pack
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNA_FP_APPS R
Operating Systems Id
APPLICATION_LABEL varchar2 1024  √  null Applications Name
MANUFACTURER varchar2 4000  √  null Application Manufacturer
APPLICATION_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNA_FP_APPS1_APPLICATION_TYPE R
Application Type
APPLICATION_EDITION varchar2 4000  √  null Application Edition
APPLICATION_VERSION varchar2 4000  √  null Application Version
INSTALLDIRECTORY varchar2 4000  √  null Installation Directory
NUMCPUS number 22  √  null Number of CPUs
APPLICATION_ID number 22
BDNA_CITRIX_VIRTAPPS.APPLICATION_ID FKM0_BDNACITRIXVIRTA R
BDNA_CITRIXLICENSEINV.APPLICATION_ID FKM1_BDNACITRIXLICEN R
BDNA_WDMDEVICES.APPLICATION_ID FKM1_BDNA_WDMDEVICES R
BDNA_INV_CATALOG_MAP.INV_ASSET_ID FKM1_BDNA_FP_APPS R
Applications Id
ISRUNNING varchar2 4000  √  null Is Running
INVENTORY_ID number 22 -1
BDNA_CITRIX_VIRTAPPS.INVENTORY_ID FKM0_BDNACITRIXVIRTA R
BDNA_CITRIXLICENSEINV.INVENTORY_ID FKM1_BDNACITRIXLICEN R
BDNA_WDMDEVICES.INVENTORY_ID FKM1_BDNA_WDMDEVICES R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_FP_APPS2_INVENTORY_ID R
BDNA_INV_CATALOG_MAP.INVENTORY_ID FKM1_BDNA_FP_APPS R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNA_FP_APPS R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA