topic A simple DQL to do a search for an IP to host in Dynatrace. in DQL

A simple DQL to do a search for an IP to host in Dynatrace.

MarwanC — Wed, 15 Nov 2023 16:28:00 GMT

I appreciate a simple DQL to search for a host name given an IP. How simple could it be?

Mizső — Wed, 15 Nov 2023 19:03:08 GMT

I hope I understand your request well. To be honest I am not a DQL guru I have just started to learn.

I would create a dashboard with this DQL (you can add other extra fields if you want).

fetch dt.entity.host
| fieldsAdd ipAddress, entity.detected_name
| filter in (ipAddress, array($IP) )

In order to work well I created a variable = IP

Variable DQL:

fetch dt.entity.host
| fieldsAdd ipAddress
| fieldsRemove entity.name, id

This is the results, you can search hosts by IP address:

I hope it helps.

Best regards,

Mizső

radek_jasinski — Thu, 16 Nov 2023 12:22:14 GMT

A very comprehensive answer 😊