VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY Instrukcja Użytkownika Pobierz pdf (Strona 41)

VMware, Inc. 41

Thischapterprovidesinformationon“CreatingCustomReports”onpage 41.

Creating Custom Reports

MostreportsaregeneratedfromthefourcoretablesdemonstratedinFigure 4‐1. Thereportscoverinventory,

dependency,andusage.Therestofthedataisjoinedforspecialreportswithoutmuchcomplication.The

followingareexamplesofreportsthataregeneratedfromtheADMexternaldatabase.

Host Inventory

Thefollowingscriptgeneratesareportofallhoststhatwerediscoveredbetween4:54P.M. ,October29,2006

and5:04P.M . ,October13,2007:

select ne.host_ips, ne.hostnames, ne.groups, ne.discovery_time

from network_element ne

where discovery_time between

to_date('2006-29-10 16:54:00', 'yyyy-dd-mm hh24:mi:ss') and to_date('2007-13-10 17:04:00',

'yyyy-dd-mm hh24:mi:ss')

Connection Inventory

Forthespecifiedtypeofconnection,sourceservice,andIPaddresses,thereportdisplaystheconnectiontype,

version,sourceservice,sourcehost,port,IPaddress,anddiscoverydate:

select dep.protocol, dep.groups, dep.src_service_name, dep.src_hostnames, dep.src_port,

dep.trg_service_name, dep.trg_hostnames, dep.trg_port, dep.discovery_time

from dependency dep

where discovery_time between

to_date('2006-29-10 16:54:00', 'yyyy-dd-mm hh24:mi:ss') and to_date('2007-13-10 17:04:00',

'yyyy-dd-mm hh24:mi:ss')

Most Used Services

Thisreportlistthe10mostusedservicesusedforaselecteddateandtime:

select * from

(

select service.primary_host_ip, service.primary_hostname, service.name, service.version,

service.vendor, service.category, max(value)as peak, sum(value) as transactions

from usage_metric metric inner join service service on service.id = metric.entity_id

where metric.time_id between 2006102916 and 2007101317 and service.name is not null

group by service.name, service.version, service.vendor, service.category,

service.primary_hostname, primary_host_ip

)

where rownum <= 10

ADM Custom Reports

1 2 ... 36 37 38 39 40 41 42 43 44

Brak uwag

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY Instrukcja Użytkownika Strona 41