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

[Mani_Muthu3001]

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}

[michiel_otten]

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

[Kenny_Gillette]

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.