VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 -... Manual de usuario

Application Discovery Manager

Repository Reference Guide

vCenter Application Discovery Manager 6.1

This document supports the version of each product listed and

supports all subsequent versions until the document is replaced

by a new edition. To check for more recent editions of this

document, see http://www.vmware.com/support/pubs.

EN-000452-00

VMware, Inc.

3401 Hillview Ave.

Palo Alto, CA 94304

www.vmware.com

2VMware, Inc.

ADM Repository Reference Guide

You can find the most up-to-date technical documentation on the VMware Web site at:

http://www.vmware.com/support/

The VMware Web site also provides the latest product updates.

If you have comments about this documentation, submit your feedback to:

docfeedback@vmware.com

intellectual property laws. VMware products are covered by one or more patents listed at

http://www.vmware.com/go/patents.

VMware is a registered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks

and names mentioned herein may be trademarks of their respective companies.

VMware, Inc. 3

Contents

AboutThisBook 5

1Introduction 7

Overview 7

HowDataIsCollected 7

SynchronizingtheExternalDatabase 8

2SetUptheExternalReportsSchemeConfigurationPolicy 11

SetUpandMonitortheExternalReportsSchemeConfigurationPolicy 11

CreatingtheExternalReportsSchemeConfigurationPolicy 11

ChecktheStatusoftheSynchronizationProcess 13

3ExternalDatabaseSetup 15

ExternalDatabaseSystemRequirements 15

MinimumHardwareRequirements 15

SoftwareRequirements 15

InstallingandConfiguringtheExternalDatabaseforOracle 16

InstalltheClient‐SideScript 16

CreatetheExternalReportingDatabaseUser 17

Createtheadm_olapTables 17

ConfiguretheSynchronizationProcess 18

InstallingandConfiguringtheExternalDatabaseforMSSQL 20

InstalltheClient‐SideScripts 20

InstalltheExternalDatabaseforMSSQLServer 20

ConfiguretheSynchronizationProcess 21

ManuallyLoadingDatatotheExternalDatabase 23

CheckingtheStatusoftheExternalDatabaseLoadProcess 24

UpgradingtheExternalDatabase 24

UpgradingforMSSQL 24

UpgradingforOracle 25

4ADMERDSchema 27

OverviewofExternalDatabaseTables 28

DatabaseStructureandDependencies 28

Address 30

Change_Log 30

CPU 30

Database 31

Dependency 31

Group_Membership 32

Installed_Software 33

IP_Route 33

Java_EE 34

Network_Element 34

Network_Interface 36

ADM Repository Reference Guide

4VMware, Inc.

Port 36

Property 37

Service 37

Storage_Device 38

Switch_Address_Forwarding 38

TimeDimension 39

UsageMetric 39

Usage_Metric_Baseline 40

Virtual_System_Settings 40

5ADMCustomReports 41

CreatingCustomReports 41

HostInventory 41

ConnectionInventory 41

MostUsedServices 41

ApplicationDependency 42

VMware, Inc. 5

TheVMwarevCenter™ApplicationDiscoveryManager(ADM)RepositoryReferenceGuideprovides

informationaboutsettingupandconfiguringtheADMexternalrepository.Itdescribesthetablestructureand

dependencieswithintheADMexternaldatabaseandalsoillustratesthetables.Tohelpyouwiththecustom

reports,thebookprovidesexamplesofreportsthatcanbegeneratedfromtheADMexternaldatabase.

Intended Audience

ThisdocumentispartoftheVMwarevCenterApplicationDiscoveryManagerdocumentationset,andis

intendedforusebycorporateInformationTechnology(IT)personnelwhoneedtomonitorenterprise

applicationsandresourcesandmakedecisionsaboutacquiring,allocating,andmodifyingtheseresources.

Readersofthisguideareexpectedtobefamiliarwiththesetopics:

Oracledatabase

SQL

VMware Technical Publications Glossary

VMware®TechnicalPublicationsprovidesaglossaryoftermsthatmightbeunfamiliartoyou.Fordefinitions

oftermsastheyareusedinVMwaretechnicaldocumentationgotohttp://www.vmware.com/support/pubs.

Document Feedback

VMwarewelcomesyoursuggestionsforimprovingourdocumentation.Ifyouhavecomments,sendyour

feedbacktodocfeedback@vmware.com.

Technical Support and Education Resources

Thefollowingsectionsdescribethetechnicalsupportresourcesavailabletoyou.Toaccessthecurrentversion

ofthisbookandotherbooks,gotohttp://www.vmware.com/support/pubs.

Online and Telephone Support

Touseonlinesupporttosubmittechnicalsupportrequests,viewyourproductandcontractinformation,and

Customerswithappropriatesupportcontractsshouldusetelephonesupportforthefastestresponseon

priority1issues.Gotohttp://www.vmware.com/support/phone_support.

Support Offerings

TofindouthowVMwaresupportofferingscanhelpmeetyourbusinessneeds,goto

http://www.vmware.com/support/services.

About This Book

ADM Repository Reference Guide

6VMware, Inc.

VMware Professional Services

VMwareEducationServicescoursesofferextensivehands‐onlabs,casestudyexamples,andcoursematerials

designedtobeusedason‐the‐jobreferencetools.Coursesareavailableonsite,intheclassroom,andlive

online.Foronsitepilotprograms andimplementationbestpractices,VMwareConsultingServicesprovides

offeringsto helpyouassess,plan,build,andmanageyourvirtualenvironment.Toaccessinformationabout

educationclasses,certificationprograms,andconsultingservices,gotohttp://www.vmware.com/services.

VMware, Inc. 7

ThischapterintroducestheVMwarevCenter™ApplicationDiscoveryManager(ADM)repositoryand

providesanoverviewthatincludesdescriptionsofdatacollection,tabletypes,andkeyfields.

Thischapterincludesthefollowingtopics:

“Overview”onpage 7

“SynchronizingtheExternalDatabase”onpage 8

Overview

TheADMprovidesstandardreportsbasedonthedatacollectedandstoredintheADMRepository.The

schemaofthenewADMExternalDatabaseissimpletounderstandandallowsyoutowritereportingqueries

overitwithoutdisruptingtheperformanceoftheotherADMservices.

How Data Is Collected

TheADMcollects,manages,andstoresdatathroughthecomponentslistedinTable 1‐1

Figure 1‐1illustrateshowdataiscollectedandstoredintheADMdatabase.

Introduction 1

Table 1-1. ADM Components

Component Description

ActiveDiscovery‐

Unix

Collectsdatafromtheconfigurationobjectsinyourdatacenter.Thefollowingdiscoverytypes

apply:

IPdiscovery—DetectshostsorotherconfigurationitemswithaspecificIPaddresswhen

passivediscoveryfailstodiscoverthem.

Detaildiscovery—ExtendstheinformationobtainedusingpassiveandIPdiscovery.Ituses

commonnetworkprotocolstoremotelyqueryserversinthemanagednetworkandobtains

supplementaryinformationaboutnetworkhoststhatisaddedtothedatabase.

ActiveDiscovery‐

Windows

AdiscoveryenginethatusesWMIbaseddiscoverypoliciesforperformingactivediscoveryon

Windowsmachines.

PassiveDiscovery Passivelyobservesthenetworktrafficbyperformingadeep‐packetanalysistodiscover

applicationsandcomponentrelationshipsinphysicalandvirtualenvironments.

Passivediscoveryalsoallowsyoutodothefollowing:

Mapdependencies.

Counttheactivityofthesedependencies.

Identifyservices.

Aggregator Receivesdatafromthediscoverycomponentsandreconcilesthedatabeforetransferringittothe

databasecomponent.TheaggregatoralsoprovidestheuserinterfaceforusingADMandisthe

integrationpointforvariousintegrations,forexample,ERDB.

Database AnOracleRDBMSusedtostorediscovereddataandADMconfiguration.

ADM Repository Reference Guide

8VMware, Inc.

Figure 1-1. Collection, Management, and Storage of ADM Data

ThedatastoredintheADMdatabasecannotbecustomizedormanipulatedforcreatingcustomreports.

Therefore,ADMprovidesfunctionalityforexportingthedataintoanADMexternalrepository,fromwhich

customreportsarecreated.

Thedatatransferredtotheexternalrepositoryisnotreal‐timedata.Itissynchronizedatregularintervalsas

definedintheExternalReportsSchemeConfigurationpolicy.

Synchronizing the External Database

Figure 1‐2illustrateshowtheADMexternaldatabaseissynchronizedwiththeADMrepositorythroughthe

ETL(Extract‐Transform‐Load)process.ExtractionandtransformationisdonethroughADMandloadingis

donebytheadm_olapcomponentontheexternaldatabasehost.

Figure 1-2. External Database Synchronization Process

Thesynchronizationprocesscomprisesofthefollowingsteps:

1ThesynchronizationistriggeredaccordingtothesettingsintheExternalReportsSchemeConfiguration

policy.

2ADMchecksthestatusofthereplicationtoensurethattheprevioussynchronizationandthatanyreport

requestsagainsttheexternaldatabasehascompleted.

3ADMextractsthedatafilesfortheloadprocessasfollows:

aTheReportSchemaisextractedandtranslatedto.csvfiles.

bThedatafilesarecompressedandplacedtogetherinasingleZiparchive.

cTheZipfileisuploadedtotheassignedFTPserver.

Database

detail passive

Discovery Management

database

server

flat files

data download

ADM_OLAP

Reporting Schema

FTP server

ADM

flat files

data upload

load flat files into

ADM_OLAP Schema

VMware, Inc. 9

Chapter 1 Introduction

4ThesystemrunningtheexternaldatabaseperiodicallycheckstheFTPserverfordatafilesbasedonthe

synchronizationscheduledefinedontheexternaldatabasesystem.

5Whenadatafileisfound,thefollowingprocesstakesplaceontheexternaldatabasesystem:

aThelatestZipfileisdownloaded.

bTheZipfileisextractedtothedecompressed.csvdatafiles.

cThedatabaseloadingisperformedusingthedatabasespecificloader.

Performance and Scalability

Thefollowingstepsindicatetheamountoftimerequiredtocompleteeachprocess:

Extractionandflatfilecreation—ThissteputilizestheADMresourcestothemaximum.Therefore,itis

scheduledtoextractthedataatnightorsomeotherperiodoflowresourceconsumptionandtoallow

enoughtimetocomplete.

Transferringthedatafiles—ThisstepinvolvesuploadingoftheflatfilesfromtheADMRepository

appliancetotheexternaldatabasehost.ThisstepdoesnotconsumemanyADMresources.However,the

transfertimemightvarygreatlybecauseofnetworkconditionsattheexternaldatabasehostsite.

Loadingthedatabase—Thisstepmighttakefewhourstocomplete.

ADM Repository Reference Guide

10 VMware, Inc.

Otros manuales para VCENTER APPLICATION DISCOVERY MANAGER 6.1 -...

Tabla de contenidos

Otros manuales de Software de VMware

VMware

VMware ESX 4.0 - GETTING STARTED UPDATE 1 Instrucciones generales

VMware

VMware THINAPP 4.6 - MIGRATING APPLICATIONS TECHNICAL... Manual de usuario

VMware

VMware VIEW 4.5 Manual

VMware

VMware VCENTER CONVERTER EN-000158-02 Manual de usuario

VMware

VMware FUS3-ENG-M-10-CP - Fusion For Mac OS X Manual de usuario

VMware

VMware VS4-ENT-PL-A - vSphere Enterprise Plus Manual de usuario

VMware

VMware SUSE LINUX ENTERPRISE SERVER Manual de usuario

VMware

VMware APPSPEED SERVER 1.5 - VCENTER APPSPEED INSTALLATION... Manual de instalación y operación

VMware

VMware VCENTER CHARGEBACK Manual de usuario

VMware

VMware VCENTER CHARGEBACK 1.5 - API Manual de usuario

VMware

VMware VSHIELD APP 1.0 - Manual

VMware

VMware VCENTER CONFIGURATION MANAGER Guía rápida

VMware

VMware VSHIELD APP 1.0.0 UPDATE 1 - API Manual de usuario

VMware

VMware ACE EN-000042-00 Manual de uso y cuidado

VMware

VMware VCENTER CHARGEBACK 1.5 - API Manual de usuario

VMware

VMware VSHIELD APP 1.0.0 UPDATE 1 - API Instrucciones de funcionamiento

VMware

VMware GLOBAL SUPPORT SERVICES Manual de usuario

VMware

VMware CLOUD COMPUTING - Manual de usuario

VMware

VMware VIRTUALIZATION AND CLOUD MANAGEMENT Guía de instalación

VMware

VMware GSX Server 3 Administration Manual de instrucciones

VMware

VMware VCENTER CHARGEBACK 1.5 - API Guía

VMware

VMware 454885-B21 - Lab Manager Standard Foundation... Manual de usuario

VMware

VMware VSHIELD APP 1.0 - Manual de usuario

VMware

VMware VLM3-ENG-CP - Lab Manager - PC Manual de usuario

Manuales populares de Software de otras marcas

COMPRO

COMPRO COMPROFM Manual de usuario

Muratec

Muratec OFFICEBRIDGE ONLINE Manual de usuario

Oracle

Oracle Contact Center Anywhere 8.1 Manual de usuario

Adobe

Adobe 65007312 - Photoshop Lightroom Manual

Avaya

Avaya NULL One-X for RIM Blackberry Manual de usuario

HP ProLiant BL420c Manual de usuario

PS Audio

PS Audio PowerPlay Manual del propietario

Brady

Brady LOCKOUT PRO 3.0 Manual de servicio

Avaya

Avaya Interaction Center Manual de usuario

Texas Instruments

Texas Instruments TI-83 Plus Silver Edition Manual

Novell

Novell GROUPWISE 8 - INTERNET AGENT Manual de usuario

Oracle

Oracle Application 9i Manual de usuario

Acer

Acer RDM Manual de usuario

Canon

Canon Vixia HF21 Manual de usuario

Canon

Canon ZR950 Manual de usuario

Samsung

Samsung Auto Backup Manual de usuario

Polycom

Polycom Vortex EF2201 Instrucciones de instalación y funcionamiento

Brocade Communications Systems

Brocade Communications Systems Brocade 8/12c Manual de usuario