VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Manual de usuario

Application Discovery ManagerRepository Reference GuidevCenter Application Discovery Manager 6.1This document supports the version of each product lis

ADM Repository Reference Guide10 VMware, Inc.

VMware, Inc. 11 2TheADMConsoleprovidesthenecessaryfunctionalityto: “SetUpandMonitortheExternalReportsSchemeConfigurationPolicy”onpa

ADM Repository Reference Guide12 VMware, Inc. 3InthePublishertab,entertheFTPsitetowhichthedatafilesarepublishedasshownbelow.where: T

VMware, Inc. 13Chapter 2 Set Up the External Reports Scheme Configuration Policy 3Enterthetimeofdaythesynchronizationoccurs.Intheaboveexampl

ADM Repository Reference Guide14 VMware, Inc.

VMware, Inc. 15 3Tousetheexternaldatabasefunctionalityyouneedtoperformthefollowingsteps: “ExternalDatabaseSystemRequirements”onpage

ADM Repository Reference Guide16 VMware, Inc.  PerlwiththeArchive::Zipmodule:PerlisbundledwithRHEL4.0,buttheArchive::Zipmoduleforhandl

VMware, Inc. 17Chapter 3 External Database Setup Create the External Reporting Database UserTo create an external reporting database user1Switchtoa

ADM Repository Reference Guide18 VMware, Inc. Configure the Synchronization ProcessTo configure the synchronization process1Configurethesync.propert

VMware, Inc. 19Chapter 3 External Database Setup bIfyouhaddefinedacustomadm_olapusernameandpasswordwhenyouhadcreatedthedatabaseusera

VMware, Inc.3401 Hillview Ave.Palo Alto, CA 94304www.vmware.com2 VMware, Inc.ADM Repository Reference Guide You can find the most up-to-date technical

ADM Repository Reference Guide20 VMware, Inc. Installing and Configuring the External Database for MS SQL Usethefollowingprocedurestoinstalland

VMware, Inc. 21Chapter 3 External Database Setup Configure the Synchronization ProcessTo configure the synchronization process1Configurethesync.prop

ADM Repository Reference Guide22 VMware, Inc. 2ConfigurethedatabaseloaderforMSSQLServers.TheSQLServerloaderscriptisconfiguredusingthes

VMware, Inc. 23Chapter 3 External Database Setup f SelecthowoftenyouwanttorunthetaskfromtheoptionsandclickNext.gDependingontheinterva

ADM Repository Reference Guide24 VMware, Inc. Checking the Status of the External Database Load ProcessUsethefollowinglogfilestocheckthestatus

VMware, Inc. 25Chapter 3 External Database Setup 7Proceedwiththeinstallationinstructionsin“InstallingandConfiguringtheExternalDatabasefor

ADM Repository Reference Guide26 VMware, Inc.

VMware, Inc. 27 4ThischapterillustratesthetablestructureanddependencieswithintheADMexternaldatabase.Italsodescribesthetableswithint

ADM Repository Reference Guide28 VMware, Inc. Overview of External Database TablesThischapterprovidesinformationabouttheexternaldatabasetables

VMware, Inc. 29Chapter 4 ADM ERD Schema Figure 4-1. External Database Structure and Dependencies

VMware, Inc. 3 ContentsAboutThisBook 51 Introduction 7Overview 7HowDataIsCollected 7SynchronizingtheExternalDatabase 82 SetUptheExternalRe

ADM Repository Reference Guide30 VMware, Inc. AddressThistableidentifiesinformationofanetworkelementconsistingofthehostname,IPaddress,a

VMware, Inc. 31Chapter 4 ADM ERD Schema Where:IDisaPrimarykeyNE_IDisaForeignkeyDatabaseThistablecontainsdatabaseserverandinstanceinform

ADM Repository Reference Guide32 VMware, Inc. Where:IDisaPrimarykeySRC_NE_IDisaForeignkey(network_element(id))SRC_SERVICE_IDisaForeignk

VMware, Inc. 33Chapter 4 ADM ERD Schema Where:ENTITY_IDisaForeignkey(network_element,service,dependency(id))Installed_SoftwareThistableconta

ADM Repository Reference Guide34 VMware, Inc. Where:IDisaPrimarykeyNE_ID,NIC_ID,andGATEWAY_NE_IDareForeignkeyJava_EEThistablecontainsJava

VMware, Inc. 35Chapter 4 ADM ERD Schema HOSTNAMES VARCHAR2(4000) Comma‐separatedlistofallhostnamesHOST_IPS VARCHAR2(4000) Comma‐separatedlistof

ADM Repository Reference Guide36 VMware, Inc. Where:IDisaPrimarykeyIS_VIRT_CONTAINERandIS_VIRTUALareForeignkey(Newin6.0andlaterversions

VMware, Inc. 37Chapter 4 ADM ERD Schema Where:IDisaPrimarykeyNE_IDandSERVICE_IDareForeignkeysPropertyThistablecontainsgeneralpurposeprop

ADM Repository Reference Guide38 VMware, Inc. Where:IDisaPrimarykeyNE_IDisaForeignkey(network_element(id))Storage_DeviceThistablerepresent

VMware, Inc. 39Chapter 4 ADM ERD Schema Where:IDisaPrimarykeyNE_ID,NIC_IDandTRG_NE_IDareForeignkeysTime DimensionThistableprovidesthetim

ADM Repository Reference Guide4 VMware, Inc. Port 36Property 37Service 37Storage_Device 38Switch_Address_Forwarding 38TimeDimension 39UsageMetric 39

ADM Repository Reference Guide40 VMware, Inc. Where:ENTITY_IDisaForeignkey(network_elementservice,dependency(id))TIME_IDisaForeignkey(tim

VMware, Inc. 41 5Thischapterprovidesinformationon“CreatingCustomReports”onpage 41.Creating Custom ReportsMostreportsaregeneratedfromthe

ADM Repository Reference Guide42 VMware, Inc. Application DependencyForthespecifiedBusinessApplication,thisreportshowseachhostandserviceth

VMware, Inc. 5 TheVMwarevCenter™ApplicationDiscoveryManager(ADM)RepositoryReferenceGuideprovidesinformationaboutsettingupandconfigurin

ADM Repository Reference Guide6 VMware, Inc. VMware Professional ServicesVMwareEducationServicescoursesofferextensivehands‐onlabs,casestudye

VMware, Inc. 7 1ThischapterintroducestheVMwarevCenter™ApplicationDiscoveryManager(ADM)repositoryandprovidesanoverviewthatincludesdesc

ADM Repository Reference Guide8 VMware, Inc. Figure 1-1. Collection, Management, and Storage of ADM DataThedatastoredintheADMdatabasecannotbe

VMware, Inc. 9Chapter 1 Introduction 4ThesystemrunningtheexternaldatabaseperiodicallycheckstheFTPserverfordatafilesbasedonthesynchron