VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY Instrukcja Użytkownika Pobierz pdf (Strona 28)

ADM Repository Reference Guide

28 VMware, Inc.

Overview of External Database Tables

Thischapterprovidesinformationabouttheexternaldatabasetables.

Database Structure and Dependencies

Figure 4‐1illustratesthestructureanddependenciesoftheADMexternaldatabase.Thearrowsoriginatefrom

aforeignkeyandarrowheadpointstothetablekeys.

Figure 4-1. External Database Structure and Dependencies

YoucanjointherelationENTITY_ID(inGroup_Membershiptable,Usage_Metrictable,andsoon)with

Network_Elementtable,Servicetable,andDependencytablealthoughitisnotshownintheERDasaforeign

key.

Fordisplaypurpose,somedataisaggregatedtoacomma‐separatedlist.Forexample:

 HOSTNAMES:Aflatlistofoneormorehostnames.

 HOST_IPS:AflatlistofallIPsofahost.

 GROUPS:Aflatlistofgroupstheentitybelongsto.

OTESomeofthecommonlyaccesseddataisduplicatedinmanytablestoavoidredundantjoins.

OS_VENDOR VARCHAR2(256)

OS_BUILD VARCHAR2(256)

OS_BUILD_TYPE VARCHAR2(256)

OS_SERVICE_PACK VARCHAR2(256)

OS_LANGUAGE VARCHAR2(256)

OS_KERNEL_VERSION VARCHAR2(256)

OS_KERNEL_RELEASE VARCHAR2(256)

OS_SWAP_MEMORY NUMBER(19)

OS_PHYS_MEMORY NUMBER(19)

OS_REGISTRATION_KEY VARCHAR2(256)

OS_SERIAL_NUMBER VARCHAR2(256)

CPU_MODEL VARCHAR2(256)

CPU_VENDOR VARCHAR2(256)

CPU_FAMILY VARCHAR2(256)

CPU_CLOCK_SPEED_HZ NUMBER(19)

CPU_CACHE_SIZE NUMBER(19)

CPU_STEPPING VARCHAR2(256)

CPU_DESCRIPTION VARCHAR2(256)

CPU_COUNT NUMBER(10)

Name Datatype

ID NUMBER(19)

NE_ID NUMBER(19)

NIC_ID NUMBER(19)

MAC VARCHAR2(100)

IP VARCHAR2(100)

HOSTNAME VARCHAR2(1024)

ADM_OLAP. ADDRESS

Name Datatype

ID NUMBER(19)

ENTITY_ID NUMBER(19)

CHANGE_TIME TIMESTAMP(6)

CHANGE_TYPE VARCHAR2(10)

PATH VARCHAR(22048)

DISPLAY_NAME VARCHAR2(255)

OLD_VALUE VARCHAR2(1024)

NEW_VALUE VARCHAR2(1024)

ADM_OLAP. CHANGE_LOG

Name Datatype

ID NUMBER(19)

NE_ID NUMBER(19)

MODEL VARCHAR2(256)

VENDOR VARCHAR2(256)

FAMILY VARCHAR2(256)

CLOCK_SPEED_HZ NUMBER(19)

CACHE_SIZE NUMBER(19)

STEPPING VARCHAR2(256)

DESCRIPTION VARCHAR2(256)

COUNT NUMBER(10)

ADM_OLAP. CPU

Name Datatype

ID NUMBER(19)

NE_ID NUMBER(19)

SERVICE_ID NUMBER(19)

VENDOR VARCHAR2(1024)

SERVER_NAME VARCHAR2(1024)

INSTANCE VARCHAR2(256)

IS_AUTO_START VARCHAR2(1)

ADM_OLAP. DATABASE

Name Datatype

ID NUMBER(19)

DEPENDENCY_TYPE VARCHAR2(100)

PROTOCOL VARCHAR2(1024)

PROTOCOL_VERSION VARCHAR2(1024)

TRANSPORT_PROTOCOL VARCHAR2(100)

URL VARCHAR2(512)

DOC_DEP_TYPE VARCHAR2(256)

SRC_IP VARCHAR2(100)

SRC_PORT NUMBER(19)

SRC_SERVICE_NAME VARCHAR2(1024)

SRC_PRIMARY_HOSTNAME VARCHAR2(1024)

SRC_PRIMARY_HOST_IP VARCHAR2(100)

SRC_HOSTNAMES VARCHAR2(4000)

SRC_HOST_IPS VARCHAR2(4000)

SRC_NE_ID NUMBER(19)

SRC_SERVICE_ID NUMBER(19)

SRC_MODULE_ID NUMBER(19)

TRG_IP VARCHAR2(100)

TRG_PORT NUMBER(19)

TRG_SERVICE_NAME VARCHAR2(1024)

TRG_PRIMARY_HOSTNAME VARCHAR2(1024)

TRG_PRIMARY_HOST_IP VARCHAR2(100)

TRG_HOSTNAMES VARCHAR2(4000)

TRG_HOST_IPS VARCHAR2(4000)

TRG_NE_ID NUMBER(19)

TRG_SERVICE_ID NUMBER(19)

TRG_MODULE_ID NUMBER(19)

GROUPS VARCHAR2(4000)

DISCOVERY_TIME TIMESTAMP(6)

KNOWLEDGE_LEVEL NUMBER(10)

Name Datatype

ID NUMBER(19)

GROUP_TYPE VARCHAR2(255)

GROUP_NAME VARCHAR2(255)

GROUP_DESCRIPTION VARCHAR2(1024)

GROUP_CREATION_TIME TIMESTAMP(6)

GROUP_CREATOR VARCHAR2(255)

GROUP_MODIFICATION_TIME TIMESTAMP(6)

GROUP_MODIFIER VARCHAR2(255)

ENTITY_ID NUMBER(19)

ADM_OLAP. GROUP_MEMBERSHIP

Name Datatype

ID NUMBER(19)

NE_ID NUMBER(19)

NAME VARCHAR2(256)

VERSION VARCHAR2(256)

RELEASE VARCHAR2(256)

VENDOR VARCHAR2(256)

INSTALL_PATH VARCHAR2(1024)

SHARED_INSTALL_PATH VARCHAR2(1024)

INSTALL_DATE TIMESTAMP(6)

TYPE VARCHAR2(256)

ADM_OLAP. INSTALLED_SOFTWARE

Name Datatype

ID NUMBER(19)

NE_ID NUMBER(19)

NIC_ID NUMBER(19)

DEST_IP VARCHAR2(100)

DEST_MASK VARCHAR2(100)

GATEWAY VARCHAR2(100)

METRIC NUMBER(10)

IS_LOCAL VARCHAR2(1)

GATEWAY_NE_ID NUMBER(19)

ADM_OLAP. IP_ROUTE

Name Datatype

ID NUMBER(19)

NE_ID NUMBER(19)

SERVICE_ID NUMBER(19)

SERVER_NAME VARCHAR2(256)

SERVER_CONFIG_PATH VARCHAR2(512)

APP_NAME VARCHAR2(256)

APP_DESCRIPTION VARCHAR2(1024)

APP_PATH VARCHAR2(1024)

MODULE_NAME VARCHAR2(256)

MODULE_TYPE VARCHAR2(256)

MODULE_DEPLOYMENT_DESC VARCHAR2(256)

MODULE_CONTEXT_ROOT VARCHAR2(256)

ADM_OLAP. JAVA_EE

Name Datatype

ID NUMBER(19)

PRIMARY_HOSTNAME VARCHAR2(1024)

PRIMARY_HOST_IP VARCHAR2(100)

HOSTNAMES VARCHAR2(4000)

HOST_IPS VARCHAR2(4000)

GROUPS VARCHAR2(4000)

DISCOVERY_TIME TIMESTAMP(6)

IS_HOST VARCHAR2(1)

IS_ROUTER VARCHAR2(1)

IS_SWITCH VARCHAR2(1)

IS_VIRT_CONTAINER VARCHAR2(1)

IS_VIRTUAL VARCHAR2(1)

HW_SERIAL VARCHAR2(256)

HW_UUID VARCHAR2(256)

HW_VENDOR VARCHAR2(256)

HW_MODEL VARCHAR2(256)

HW_DESCRIPTION VARCHAR2(1024)

OS_NAME VARCHAR2(256)

OS_FAMILY VARCHAR2(256)

OS_TYPE VARCHAR2(256)

OS_VERSION VARCHAR2(256)

ADM_OLAP. NETWORK_ELEMENT

Name Datatype

ID NUMBER(19)

NE_ID NUMBER(19)

IS_LOCAL VARCHAR2(1)

MAC_ADDRESS VARCHAR2(256)

MODEL VARCHAR2(256)

VENDOR VARCHAR2(256)

TECHNOLOGY VARCHAR2(256)

SPEED_BIT_PS VARCHAR2(256)

DESCRIPTION VARCHAR2(256)

OP_STATUS VARCHAR2(256)

IS_VIRTUAL VARCHAR2(1)

IS_TRUNK VARCHAR2(1)

IS_DEFAULT VARCHAR2(1)

PORT_LABEL VARCHAR2(256)

MODULE_LABEL VARCHAR2(256)

V_LAN NUMBER(10)

ADM_OLAP. NETWORK_INTERFACE

Name Datatype

ID NUMBER(19)

NE_ID NUMBER(19)

SERVICE_ID NUMBER(19)

IP VARCHAR2(100)

PORT NUMBER(5)

TRANSPORT_PROTOCOL VARCHAR2(100)

ADM_OLAP. PORT

Name Datatype

ID NUMBER(19)

NAME VARCHAR2(1024)

NE_ID NUMBER(19)

PRIMARY_HOSTNAME VARCHAR2(1024)

PRIMARY_HOST_IP VARCHAR2(100)

ADM_OLAP. SERVICE

Name Datatype

ID NUMBER(19)

ENTITY_ID NUMBER(19)

NAME VARCHAR2(256)

VALUE VARCHAR2(1028)

ADM_OLAP. PROPERTY

HOSTNAMES VARCHAR2(4000)

HOST_IPS VARCHAR2(4000)

PORTS VARCHAR2(4000)

GROUPS VARCHAR2(4000)

DISCOVERY_TIME TIMESTAMP(6)

VENDOR VARCHAR2(1024)

VERSION VARCHAR2(1024)

CATEGORY VARCHAR2(100)

TIER VARCHAR2(100)

INSTALL_PATH VARCHAR2(512)

SHARED_INSTALL_PATH VARCHAR2(512)

IS_UNIDENTIFIED VARCHAR2(1)

IS_CLIENT VARCHAR2(1)

KNOWLEDGE_LEVEL NUMBER(10)

Name Datatype

ID NUMBER(19)

NE_ID NUMBER(19)

IS_LOGICAL VARCHAR2(1)

LABEL VARCHAR2(256)

DESCRIPTION VARCHAR2(256)

DEVICE_TYPE VARCHAR2(256)

CAPACITY NUMBER(19)

FILE_SYSTEM VARCHAR2(256)

MOUNT_DESTINATION VARCHAR2(256)

MOUNT_POINT VARCHAR2(256)

ADM_OLAP. STORAGE_DEVICE

Name Datatype

ID NUMBER(19)

NE_ID NUMBER(19)

NIC_ID NUMBER(19)

MODULE VARCHAR2(256)

PORT VARCHAR2(256)

MAC VARCHAR2(100)

V_LAN NUMBER(10)

TRG_NE_ID NUMBER(19)

ADM_OLAP. SWITCH_ADDRESS

_FORWARDING

Name Datatype

TIME_ID NUMBER(19)

YEAR NUMBER(10)

QUARTER NUMBER(10)

QUARTER_NAME VARCHAR2(50)

MONTH NUMBER(10)

MONTH_NAME VARCHAR2(50)

DAY_OF_MONTH NUMBER(10)

DAY_OF_WEEK NUMBER(10)

DAY_OF_WEEK_NAME VARCHAR2(50)

WEEK_OF_YEAR NUMBER(10)

HOUR NUMBER(10)

ADM_OLAP. TIME

Name Datatype

ENTITY_ID NUMBER(19)

TIME_ID NUMBER(19)

BASELINE_TIME_ID NUMBER(19)

VALUE NUMBER(19)

Name Datatype

BASELINE_TIME_ID NUMBER(19)

ENTITY_ID NUMBER(19)

VALUE NUMBER(19)

Name Datatype

ID NUMBER(19)

CONTAINER_ID NUMBER(19)

UUID VARCHAR2(256)

STATE VARCHAR2(256)

VM_NAME VARCHAR2(256)

OS_FAMILY VARCHAR2(256)

OS_NAME VARCHAR2(256)

OS_TYPE VARCHAR2(256)

TOOLS_STATUS VARCHAR2(256)

TOOLS_VERSION VARCHAR2(256)

TOTAL_MEM_SIZE NUMBER(19)

IPS VARCHAR2(1024)

MACS VARCHAR2(4000)

VIRTUAL_NE_ID NUMBER(19)

ADM_OLAP. USAGE_METRIC

ADM_OLAP. USAGE_METRIC_BASELINE

ADM_OLAP. VIRTUAL_SYSTEM

_SETTINGS

ADM_OLAP.DEPENDENCY

1 2 ... 23 24 25 26 27 28 29 30 31 32 33 ... 43 44

Komentarze do niniejszej Instrukcji

Brak uwag

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY Instrukcja Użytkownika Strona 28

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie bazy danych VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY