ADM Repository Reference Guide
42 VMware, Inc.
Application Dependency
ForthespecifiedBusinessApplication,thisreportshowseachhostandservicetheapplicationdependsonand
eachhostandservicethatdependsonit(ifany):
select distinct 0 as degree, grp.group_name, service.name, service.version, service.vendor,
service.category, service.primary_host_ip, service.primary_hostname,
service.discovery_time
from dependency dep inner join group_membership grp on grp.entity_id = dep.id
inner join service service on service.id =dep.src_service_id
where service.name is not null and grp.group_name = '111'
union
select distinct 1 as degree, grp.group_name, service.name, service.version, service.vendor,
service.category,
service.primary_host_ip, service.primary_hostname, service.discovery_time
from dependency dep inner join group_membership grp on grp.entity_id = dep.id
inner join service service on service.id =dep.trg_service_id
where service.name is not null and grp.group_name = '111'
Commentaires sur ces manuels