VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 -... Manuel utilisateur

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.

Autres manuels pour VCENTER APPLICATION DISCOVERY MANAGER 6.1 -...

Table des matières

Autres manuels VMware Logiciel

VMware

VMware VCENTER CONFIGURATION MANAGER Guide rapide

VMware

VMware VCLOUD REQUEST MANAGER 1.0.0 Manuel utilisateur

VMware

VMware VCENTER CHARGEBACK Manuel utilisateur

VMware

VMware VCM 5.3 - CONFIGURATION MANAGER SECURITY ENVIRONMENT... Guide rapide

VMware

VMware ZIMBRA Guide d'installation

VMware

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 -... Mode d’emploi

VMware

VMware vSphere 4 Manuel d'installation et d'exploitation

VMware

VMware VSHIELD APP Manuel utilisateur

VMware

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.0 Manuel utilisateur

VMware

VMware VIEW 4.5 Guide de configuration rapide

VMware

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 -... Mode d’emploi

VMware

VMware VIEW 4.5 Manuel utilisateur

VMware

VMware CLOUD COMPUTING - Manuel utilisateur

VMware

VMware 4817V62 - vSphere - PC Mode d’emploi

VMware

VMware vSphere 4 Manuel utilisateur

VMware

VMware VIEW MANAGER 4.X - EXTENDING VIRTUAL MACHINE DELECTION WITH... Manuel utilisateur

VMware

VMware ESX 4.0 - GETTING STARTED UPDATE 1 Manuel utilisateur

VMware

VMware CLOUD DIRECTOR 1.0 Manuel utilisateur

VMware

VMware VCLOUD DIRECTOR Manuel utilisateur

VMware

VMware THINAPP Manuel utilisateur

VMware

VMware VCENTER CONVERTER EN-000158-02 Manuel utilisateur

VMware

VMware VCENTER CONFIGURATION MANAGER 5.3 - VCENTER DISCOVERED MACHINES IMPORT TOOL... Manuel utilisateur

VMware

VMware VSHIELD APP 1.0.0 UPDATE 1 - API Mode d'emploi

VMware

VMware VCENTER CONFIGURATION MANAGER 5.3 - SOFTWARE REQUIEREMENTS... Guide rapide

Manuels Logiciel populaires d'autres marques

COMPRO

COMPRO COMPROFM Manuel utilisateur

Muratec

Muratec OFFICEBRIDGE ONLINE Manuel utilisateur

Oracle

Oracle Contact Center Anywhere 8.1 Manuel utilisateur

Adobe

Adobe 65007312 - Photoshop Lightroom Manuel

Avaya

Avaya NULL One-X for RIM Blackberry Manuel utilisateur

HP ProLiant BL420c Manuel utilisateur

PS Audio

PS Audio PowerPlay Manuel du propriétaire

Brady

Brady LOCKOUT PRO 3.0 Manuel de service

Avaya

Avaya Interaction Center Manuel utilisateur

Texas Instruments

Texas Instruments TI-83 Plus Silver Edition Manuel

Novell

Novell GROUPWISE 8 - INTERNET AGENT Manuel utilisateur

Oracle

Oracle Application 9i Manuel utilisateur

Acer

Acer RDM Manuel utilisateur

Canon

Canon Vixia HF21 Manuel utilisateur

Canon

Canon ZR950 Manuel utilisateur

Samsung

Samsung Auto Backup Manuel utilisateur

Polycom

Polycom Vortex EF2201 Instructions d'installation et d'utilisation

Brocade Communications Systems

Brocade Communications Systems Brocade 8/12c Manuel utilisateur