VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Manuale Utente

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