Retrieve Entity Names Using DQL for Accurate Query Results

Pablo2 — Wed, 17 Dec 2025 13:05:12 GMT

I have the following DQL to retrieve entities related to a host, but I need to know the entity name and not the IDs. Is there any way to obtain them?

fetch dt.entity.host
| filter entity.name == ‘DAMA2021.ppcloudmgmt.intraxa’
| fieldsAdd calls, called_by, instance_of, contains, runs, belongs_to

Re: Entity Names in DQL

deni — Tue, 07 Oct 2025 09:12:11 GMT

Hi @Pablo2 ,

fetch dt.entity.host | fieldsFlatten calls | expand callId = calls.dt.entity.host | lookup sourceField: callId, lookupField: id, [ fetch dt.entity.host | fields id, entity.name ] | summarize callNames = collectDistinct(lookup.entity.name), by:{id, entity.name } | sort entity.name

I suppose you need something like this? It is only for calls, but can be extended for the other fields.

Regards, Deni

Re: Entity Names in DQL

t_pawlak — Wed, 08 Oct 2025 11:03:34 GMT

Hi @Pablo2
@deni is right. Here are a few additional variants you can use depending on your needs:
Just the raw call IDs (split into rows):

2. IDs + resolved entity names (with lookup):

fetch dt.entity.host | filter entity.name == "easytravel-demo1" | fieldsKeep id, entity.name, calls | fieldsFlatten calls | expand callId = calls.dt.entity.host | lookup sourceField: callId, lookupField: id, [ fetch dt.entity.host | fields id, entity.name ] | summarize callNames = collectDistinct(lookup.entity.name), by:{ id, entity.name }

3. Filtered by prefix/substring in the name:

fetch dt.entity.host | filter entity.name == "easytravel-demo1" | fieldsKeep id, entity.name, calls | fieldsFlatten calls | expand callId = calls.dt.entity.host | lookup sourceField: callId, lookupField: id, [ fetch dt.entity.host | fields id, entity.name ] | filter startsWith(lower(lookup.entity.name), "aks-") | filter contains(lower(lookup.entity.name), "dynatrace.org") | summarize callNames = collectDistinct(lookup.entity.name), by:{ id, entity.name }

4. One row per call (no aggregation, raw list):

topic Re: Entity Names in DQL in DQL

Retrieve Entity Names Using DQL for Accurate Query Results

Re: Entity Names in DQL

Re: Entity Names in DQL