BDNA Discover Publish version 7.7.2 with 201708
BDNA_VIRT_MACHINES - All Virtual Machines

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
VM_ID number 22
BDNA_ALL_VIRT_ENT.VM_ID FKM0_BDNAALLVIRTENT R
BDNA_MASTER_OS_MAP.UNSCANNED_VM_ID FKM2_BDNAMASTEROSMAP R
BDNA_MICROSOFT_VMS.VM_ID FKM0_BDNAMICROSOFTVM R
BDNA_ORACLE_VMS.VM_ID FKM0_BDNA_ORACLE_VMS R
BDNA_VIRT_DEV_VM_REL.VM_ID FKM1_BDNAVIRTDEVVMRE R
BDNA_VM_MACS.VM_ID FKM0_BDNA_VM_MACS R
BDNA_VMWARE_VMS.VM_ID FKM0_BDNA_VMWARE_VMS R
BDNA_XEN_OR_ORACLE_VMS.VM_ID FKM0_BDNAXENORORACLE R
BDNA_XEN_VMS.VM_ID FKM0_BDNA_XEN_VMS R
Virtual Machine Id
VM_OS_ID number 22  √  null
BDNA_VIRT_OS.OPERATINGSYSTEM_ID FKM0_BDNAVIRTMACHINE R
VM OS Id
VM_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNA_VIRT_MACHINES0_VM_TYPE R
VM Type
VM_GENERIC_TYPE_STR varchar2 16  √  null Generic Type String for Virtual Machine
VM_SPECIFIC_TYPE_STR varchar2 4000  √  null Specific Type String for Virtual Machine
VM_NAME varchar2 4000  √  null Virtual Machine Name
VM_REG_NAME varchar2 4000  √  null Virtual Machine Registration Name
IS_SCANNED_AT_L2 varchar2 4000  √  null Is VM Scanned at L2?
IS_RUNNING varchar2 4000  √  null Is VM Running?
IS_IN_HOST_CONFIG_FILE varchar2 4000  √  null IsVM found in Host Configuration File?
PARENT_OS_ID number 22  √  null
BDNA_VIRT_OS.OPERATINGSYSTEM_ID FKM1_BDNAVIRTMACHINE R
Parent OS Id
INVENTORY_ID number 22 -1
BDNA_ALL_VIRT_ENT.INVENTORY_ID FKM0_BDNAALLVIRTENT R
BDNA_MASTER_OS_MAP.INVENTORY_ID FKM2_BDNAMASTEROSMAP R
BDNA_MICROSOFT_VMS.INVENTORY_ID FKM0_BDNAMICROSOFTVM R
BDNA_ORACLE_VMS.INVENTORY_ID FKM0_BDNA_ORACLE_VMS R
BDNA_VIRT_DEV_VM_REL.INVENTORY_ID FKM1_BDNAVIRTDEVVMRE R
BDNA_VM_MACS.INVENTORY_ID FKM0_BDNA_VM_MACS R
BDNA_VMWARE_VMS.INVENTORY_ID FKM0_BDNA_VMWARE_VMS R
BDNA_XEN_OR_ORACLE_VMS.INVENTORY_ID FKM0_BDNAXENORORACLE R
BDNA_XEN_VMS.INVENTORY_ID FKM0_BDNA_XEN_VMS R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAVIRTMACHINES1_INVENTORY_ID R
BDNA_VIRT_OS.INVENTORY_ID FKM0_BDNAVIRTMACHINE R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA