topic Re: DQL to pull all Endpoints\Requests for a particular Service in DQL

DQL to pull all Endpoints\Requests for a particular Service

dkrishna — Wed, 22 Apr 2026 08:19:11 GMT

Hi,

I am trying to pull all the endpoints of a service but i am unable to fetch instead we can fetch only the endpoints which are marked key requests. Need help on this.

Please let me know if you are unclear on question.

Thanks in advance.

Re: DQL to pull all Endpoints\Requests for a particular Service

MaximilianoML — Wed, 22 Apr 2026 08:39:23 GMT

Hello @dkrishna,

If I understood correctly, you want something like this bellow:

fetch spans | filter dt.smartscape.service == toSmartscapeId("SERVICE-xxxxxxx") | filter transaction.is_root_span == true | filter transaction.is_endpoint_request == true | filter isNotNull(endpoint.name) | summarize requests = count(), by: { endpoint.name } | sort requests desc

I hope this helps you 😀

Re: DQL to pull all Endpoints\Requests for a particular Service

dkrishna — Thu, 23 Apr 2026 09:34:04 GMT

Hi MaximilianoML,

Good morning.

Hope you are doing good.

Thanks for your valuable inputs, its really worked but it is fetching only "Non Key Requests". whereas I am looking for both Key Requests as well as Non Key Requests.

Many Thanks in Advance.

Re: DQL to pull all Endpoints\Requests for a particular Service

dkrishna — Thu, 23 Apr 2026 09:44:31 GMT

And also is there a way to differentiate Key Requests and Non Key Requests.

Re: DQL to pull all Endpoints\Requests for a particular Service

MaximilianoML — Thu, 23 Apr 2026 10:53:32 GMT

Hello, @dkrishna,

Unfortunately I don't think it's possible to filter them like we want here, so I post a Product Idea here

I think we can close this thread now, I hope it helped you 😊

Re: DQL to pull all Endpoints\Requests for a particular Service

dkrishna — Thu, 23 Apr 2026 11:12:13 GMT

Ok, Yes it was a great help. Thank you so much.

Re: DQL to pull all Endpoints\Requests for a particular Service

dkrishna — Thu, 23 Apr 2026 11:37:30 GMT

Hi @MaximilianoML

Sorry i last thing i missed to ask, can I have Failure rate, Response time and HTTP 5xx errors filters please.

Re: DQL to pull all Endpoints\Requests for a particular Service

MaximilianoML — Thu, 23 Apr 2026 11:56:53 GMT

You're always free to comeback and ask more questions!

You might want something like this bellow:

fetch spans | filter dt.smartscape.service == toSmartscapeId("SERVICE-xxxxxxxxx") | filter request.is_root_span == true | filter transaction.is_root_span == true | filter transaction.is_endpoint_request == true | filter isNotNull(endpoint.name) | summarize requests = count(), failures = countIf(request.is_failed == true), avg_response_time = avg(duration), http_5xx = countIf(http.response.status_code >= 500 and http.response.status_code < 600), by: { endpoint.name } | fieldsAdd failure_rate = if(requests > 0, 100.0 * failures / requests, else: 0.0) | sort requests desc