6.1
Table Of Contents
- Application Discovery Manager Repository Reference Guide
- Contents
- About This Book
- Introduction
- Set Up the External Reports Scheme Configuration Policy
- External Database Setup
- ADM ERD Schema
- ADM Custom Reports
ADM Repository Reference Guide
28 VMware, Inc.
Overview of External Database Tables
Thischapterprovidesinformationabouttheexternaldatabasetables.
Database Structure and Dependencies
Figure 4‐1illustratesthestructureanddependenciesoftheADMexternaldatabase.Arrowheadsareusedto
identifythetablekeys.
Itisimportanttonotethatsomeofthecommonlyaccesseddataisduplicatedinmanytablestoavoid
unnecessaryjoins.
Fordisplaypurposes,somedataisaggregatedtoa
comma‐separatedlist.Forexample:
hostnames–aflatlistofoneormorehostnames.
host_ips–aflatlistofallIPsofahost.
groups–aflatlistofgroupstheentitybelongsto.
Asinglerelationcalledentity_id(ingroupmembership,usagemetric,etc.)couldbejoinedwithallthree
“entity”tables(network_element,service,anddependency)althoughitisnotshownintheERDasa
foreignkey.