How do I get Dynatrace to display friendly hostnames when I am creating widgets for my dashboard

[badgerfifteen]

I am in the process of creating widgets for my dashboard. For one of them, I have created a widget which displays the utilisation of a server, along with its corresponding disk. I have managed to create one, but it just displays it in the most unfriendly way possible. Like "DISK-2091822KAPQKA". Is there a DQL command where I can make Dynatrace use friendly names, ones which make sense to the user. 

Thanks! 🙂

[LawrenceBarratt · Accepted solution]

Hi @badgerfifteen 

There is a field called disk.entity.name you can do a lookup on.

Example DQL below:

 timeseries {rtime=avg(dt.host.disk.read_time), rops=avg(dt.host.disk.read_ops) }, by: {dt.entity.host, dt.entity.disk}

 | lookup [fetch dt.entity.host | fieldsAdd tags], lookupField:id , sourceField:dt.entity.host, prefix:"host."

  | lookup [fetch dt.entity.disk ], lookupField:id , sourceField:dt.entity.disk, prefix:"disk."

 | summarize avg(rtime[]), avg(rops[]), by:{interval, timeframe, disk.entity.name}

Thanks,

Lawrence