VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 -... User manual

Application Discovery Manager

Repository Reference Guide

vCenter Application Discovery Manager 6.1.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-01

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 23

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 29

Change_Log 29

CPU 29

Database 30

Dependency 30

Group_Membership 31

Installed_Software 32

IP_Route 32

Java_EE 33

Network_Element 33

Network_Interface 34

ADM Repository Reference Guide

4VMware, Inc.

Port 35

Property 35

Service 36

Storage_Device 36

Switch_Address_Forwarding 37

Time 37

Usage_Metric 38

Usage_Metric_Baseline 38

Virtual_System_Settings 38

5ADMCustomReports 41

CreatingCustomReports 41

HostInventory 41

ConnectionInventory 41

MostUsedServices 41

ApplicationDependency 42

Index 43

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.

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.

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

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.

Other manuals for VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 -...

Table of contents

Other VMware Software manuals

VMware

VMware VSHIELD User manual

VMware

VMware VCLOUD DIRECTOR User manual

VMware

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.0 User manual

VMware

VMware VCM 5.3 User manual

VMware

VMware ESX 4.0 - GETTING STARTED UPDATE 1 General instructions

VMware

VMware GLOBAL SUPPORT SERVICES User manual

VMware

VMware vSphere 4 Installation and operation manual

VMware

VMware VIEW 4.5 - ARCHITECTURE PLANNING... User manual

VMware

VMware VCENTER CHARGEBACK User manual

VMware

VMware VSHIELD ENDPOINT User manual

VMware

VMware SUSE LINUX ENTERPRISE SERVER User manual

VMware

VMware VCENTER APPLICATION DISCOVERY MANAGER User manual

VMware

VMware CLOUD DIRECTOR 1.0 User manual

VMware

VMware VCLOUD REQUEST MANAGER 1.0.0 User manual

VMware

VMware VCENTER CAPACITYIQ 1.5 User manual

VMware

VMware VSHIELD APP 1.0 - API Operating instructions

VMware

VMware APPSPEED SERVER 1.5 - VCENTER APPSPEED INSTALLATION... User manual

VMware

VMware ZIMBRA Installation guide

VMware

VMware VCENTER CHARGEBACK 1.5 - API User manual

VMware

VMware VIRTUALIZATION AND CLOUD MANAGEMENT Installation guide

VMware

VMware GSX Server 3 Administration Instruction Manual

VMware

VMware VCLOUD SDK FOR JAVA 1.0 - DEVELOPER S GUIDE User manual

VMware

VMware VSHIELD EDGE User manual

VMware

VMware THINAPP 4.6 - MIGRATING APPLICATIONS TECHNICAL... User manual

Popular Software manuals by other brands

COMPRO

COMPRO COMPROFM manual

Muratec

Muratec OFFICEBRIDGE ONLINE user guide

Oracle

Oracle Contact Center Anywhere 8.1 installation guide

Adobe

Adobe 65007312 - Photoshop Lightroom Programmer's guide

Avaya

Avaya NULL One-X for RIM Blackberry user guide

HP ProLiant BL420c user guide

PS Audio

PS Audio PowerPlay Programming manual

Brady

Brady LOCKOUT PRO 3.0 Administrator's guide

Avaya

Avaya Interaction Center user guide

Texas Instruments

Texas Instruments TI-83 Plus Silver Edition Guide book

Novell

Novell GROUPWISE 8 - INTERNET AGENT manual

Oracle

Oracle Application 9i Configuration guide

Acer

Acer RDM user guide

Canon

Canon Vixia HF21 instruction manual

Canon

Canon ZR950 instruction manual

Samsung

Samsung Auto Backup user manual

Polycom

Polycom Vortex EF2201 Application note

Brocade Communications Systems

Brocade Communications Systems Brocade 8/12c user manual