topic Re: Fetch Problems and Sort by Application in DQL

Fetch and Sort Problems by Application Using DQL

sjena7810 — Thu, 18 Dec 2025 12:37:58 GMT

Hi all!

I have a dashboard where I want to fetch all the active problems and group the problems together by application. Then, using a variable that sorts through applications, I want to use that variable as a multi-select filter.

However, when I fetch active problems, I don't see any category that groups together problems by application. I see options to group by alerting_profile, display_id, affected_entity_id, etc..., but nothing to group by app.

Is there any way to sort through the list of active problems and group them together by application?

Re: Fetch Problems and Sort by Application

DavidRitter — Tue, 04 Feb 2025 19:23:36 GMT

Just to clarify, what do you mean by application? Do you mean Dynatrace Application (RUM)? If you mean RUM app you could try something like this:

fetch dt.davis.problems
| expand affected_entity_types
| filter affected_entity_types == "dt.entity.application"
| dedup display_id

To get all of the problems related to your DT RUM applications

Re: Fetch Problems and Sort by Application

sjena7810 — Wed, 05 Feb 2025 19:43:13 GMT

Hey, thanks for the response David.

By "application", I mean the applications at our firm that we have OneAgent installed on (Salesforce, Docusign, etc...).

I want to get the total number of problems per application (or even management zone). However, when I fetch Davis problems, I don't see any options (columns) that allow me to filter by application (or anything even remotely close).

| fetch dt.davis.problems | expand affected_entity_types

When I run this, none of the columns signify the application that the problem occurs on. When I run your DQL query, I don't see the actual names of apps, just whether or not the problem occurred on an application, host, server, etc.

Re: Fetch Problems and Sort by Application

Maheedhar_T — Thu, 06 Feb 2025 04:18:49 GMT

Heya,
You can filter by entity_ids like this.

fetch dt.davis.problems | expand affected_entity_ids | summarize count(), by: affected_entity_ids

however, if you want application names instead of ids then it would be complex one as the DQL will only allow fetching entities by their type and get their name like you can get an application name by using a query like this

fetch dt.entity.application | filter id == "APPLICATION-<ALPHA-NUMERIC-ID>" | fields entity.name

Since you mentioned you are using dashboard itself, I'd suggest use the query1 as a variable and write a JS code that would fetch the entity.name by the entity id.

Refer this on how you can write JS code DQL Query | Dynatrace Developer

Hope this helps..

Regards,
Maheedhar.

Re: Fetch Problems and Sort by Application

sjena7810 — Fri, 07 Feb 2025 14:36:27 GMT

Hi Maheedhar, thanks for the response.

When you say:

| filter id == "APPLICATION-<ALPHA-NUMERIC-ID>"

What does ALPHA-NUMERIC-ID refer to? Is that the display ID of the problem? Like, P-12345?