topic How to display entity name of affected entityID for problems of different entity types in Dashboard in DQL

How to display entity name of affected entityID for problems of different entity types in Dashboard

Mani_Muthu3001 — Mon, 29 Dec 2025 08:51:41 GMT

Hi,

I am creating dashboard to find reoccurence of problems and count the reoccurrence . But I want entity name for affected entity id instead of entity id to show in dashboard. We have mutliple entity types in our environment like dt.entity.custom_device, dt.entity.host and several others(20 different entity types).

How to display affected entity name instead of entity id in dashboard.

Below is DQL

fetch dt.davis_problems |

expand affected_entity_ids |

filter in(event.status, {"ACTIVE", "CLOSED"}) |

summarize {occurences = count()}, by: {affected_entity_ids, event.name, event.description}

Re: How to display entity name of affected entityID for problems of different entity types in Dashboard

michiel_otten — Mon, 29 Dec 2025 13:10:58 GMT

I'm affraid you;'ll need to manually map all the entities to use the feature entityName(). It does not allow any wildcards nor does it allow variables. See also:
https://community.dynatrace.com/t5/DQL/Get-Host-Name-in-Open-Events/m-p/230190

Re: How to display entity name of affected entityID for problems of different entity types in Dashboard

Kenny_Gillette — Mon, 29 Dec 2025 15:38:29 GMT

I got a dashboard that might help you. I tried to share in the DT Playground but unable to. I attached file to this. Hope it helps.