BDNA Discover Publish version 7.7.1 with 201612 Sequence
BDNA_VMWARE_VMS - VMware 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_VIRT_MACHINES.VM_ID FKM0_BDNA_VMWARE_VMS R
Virtual Machine Id
VM_OS_ID number 22  √  null
BDNA_VIRT_OS.OPERATINGSYSTEM_ID FKM1_BDNA_VMWARE_VMS R
VM OS Id
IS_SCANNED_AT_L2 varchar2 4000  √  null Is Guest Scanned at L2?
IS_RUNNING varchar2 4000  √  null Is Guest Running?
IS_IN_HOST_CONFIG_FILE varchar2 4000  √  null Is Guest found in Configuration File?
PARENT_OS_ID number 22  √  null
BDNA_VIRT_OS.OPERATINGSYSTEM_ID FKM2_BDNA_VMWARE_VMS R
Parent OS Id
VM_NAME varchar2 4000  √  null VMGuest Name
VM_REG_NAME varchar2 4000  √  null VMGuest Registration Name
CONFIG_OS_TYPE varchar2 4000  √  null Guest OS Type(Configured)
CONFIG_TOTALMEMORY varchar2 4000  √  null Memory Size(Configured)
CONFIG_VERSION varchar2 4000  √  null Configuration Version
CONFIG_FILE_PATH varchar2 4000  √  null Configuration File Path
CONFIG_BIOS_UUID varchar2 4000  √  null BIOS UUID
CONFIG_IS_ETH_PRESENT varchar2 4000  √  null Is Ethernet Adapter Present
CONFIG_ETH_ADDRTYPE varchar2 4000  √  null Ethernet Address Type
CONFIG_LOC_UUID varchar2 4000  √  null Location UUID
CONFIG_VIRT_HWVER varchar2 4000  √  null Hardware Version
VM_GENERIC_TYPE_STR char 9  √  null Generic Type String for Virtual Machine
VM_SPECIFIC_TYPE_STR varchar2 4000  √  null Specific Type String for Virtual Machine
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_VMWARE_VMS0_INVENTORY_ID R
BDNA_VIRT_OS.INVENTORY_ID FKM1_BDNA_VMWARE_VMS R
BDNA_VIRT_MACHINES.INVENTORY_ID FKM0_BDNA_VMWARE_VMS R
Inventory Id

Analyzed at Fri Oct 21 21:10 PDT 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA