Hello,
I need a DQL to answer the following questions:
- What is the response time, failure count and throughput of Service B that is called by Service A. The result need to be only for the calls that Service A make to Service B.
I created a DQL that show the services dependency. But could not get the metrics I need.
fetch dt.entity.service
| expand calledby_service=called_by[dt.entity.service]
| expand calls_service=calls[dt.entity.service]
| fieldsAdd service_type = serviceType, clusteredBy = clustered_by[dt.entity.kubernetes_cluster][0], belongsToNamespace = belongs_to[dt.entity.cloud_application_namespace][0], belongsToApp = belongs_to[dt.entity.cloud_application][0],instantiates= instantiates[dt.entity.service_instance][0]
| lookup [fetch dt.entity.service], sourceField:calledby_service, lookupField:id, fields:{Incoming=entity.name}
| lookup [fetch dt.entity.service], sourceField:calls_service, lookupField:id, fields:{Outgoing=entity.name}
| lookup [fetch dt.entity.kubernetes_cluster], sourceField:clusteredBy, lookupField:id, fields:{Cluster = entity.name}
| lookup [fetch dt.entity.cloud_application_namespace], sourceField:belongsToNamespace, lookupField:id, fields:{Namespace = entity.name}
| fields service_type, service=entity.name, Incoming ,Outgoing, Namespace, Cluster
| summarize count(), by:{service,Incoming,Outgoing}
