Timeseries of service request count sum by host

[imrj99]

I would like to have a timeseries that includes the sum of total requests count by host, very similar to the post below, but w/o the service name, and the count summed up by hosts (i will pull in hosts from a mgmtzone variable)

https://community.dynatrace.com/t5/DQL/Service-request-counts-per-host-server/td-p/281087

[Julius_Loman]

You can't do this with the built-in service metrics (service metrics are already aggregated and do not contain host dimension), but you can grab it from spans:

fetch spans
| filter span.kind=="server"
| makeTimeseries count(), by:{host.name}

or create your own metric in OpenPipeline for spans. 

Just take into account that not all spans must be captured (sampling / adaptive traffic management), so you might see lower values than the actual count.

[imrj99]

so there is no way i could sum up the counts for each unique host? am afraid with spans am going to get a lot of other things than just specific service request counts

what am looking for is exactly like this screenshot below, but removing the service name and just sum the service request counts at the unique host level

[dannemca · Accepted solution]

just add this at the end of this current DQL you have for this table

|summarize sum(Request Count), by:{Host Name}

replacing the respective Request Count and Host Name fields by the one you have in your query.

[imrj99]

sweet deal, that worked perfectly! thanks

[Julius_Loman]

@imrj99 If you grabbed the DQL from the referenced thread, then this will work only for services which have one instance (one host).  There is no way of doing from dt.service.request.count metric for process groups which have more than one instance.

[imrj99]

yup you are correct indeed, I noticed that shortly after, only a few hosts are coming up on the query and its for exactly the reason you mentioned. so spans must be the only way then...

[Julius_Loman · Accepted solution]

@imrj99 spans are the way if you need to see it for some analysis. For dashboards, create a metric in OpenPipeline span pipeline to calculate it.