I have a grafana with Prometheus, InfluxDB and MySQL plugins installed. I want to get the IP behind a domain name, for example, get 8.8.8.8 when querying dns.google.com, and show the result in a Grafana Dashboard.

I tried to :

• Use MySQL query to get it. But everything I found is about the IP of the client
• Use Grafana Agent that doesn’t seems to be answering to my issue (cannot use it in grafan dashboard).
• Find a Datasource or in plugin list, but I didn’t find anything that can do this type of query.
• Find a way to use PHP as the method gethostbyname($ip) do exactly what I want, but I can’t execute PHP.

I don’t want to save the result to have an history, I just want a real-time DNS manager to check for some DNS entry.

How can I do it?