topic Re: timeseries of service request count sum by host in DQL

Timeseries of service request count sum by host

imrj99 — Thu, 28 Aug 2025 15:34:14 GMT

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

Re: timeseries of service request count sum by host

Julius_Loman — Tue, 26 Aug 2025 18:05:51 GMT

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.

Re: timeseries of service request count sum by host

imrj99 — Tue, 26 Aug 2025 18:46:09 GMT

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

Re: timeseries of service request count sum by host

dannemca — Tue, 26 Aug 2025 19:07:28 GMT

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.

Re: timeseries of service request count sum by host

imrj99 — Tue, 26 Aug 2025 19:21:07 GMT

sweet deal, that worked perfectly! thanks

Re: timeseries of service request count sum by host

Julius_Loman — Tue, 26 Aug 2025 20:54:22 GMT

@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.

Re: timeseries of service request count sum by host

imrj99 — Wed, 27 Aug 2025 12:13:18 GMT

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...

Re: timeseries of service request count sum by host

Julius_Loman — Wed, 27 Aug 2025 12:48:34 GMT

@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.