Host Availability Dashboard Pane

m_laurie_az — Mon, 28 Apr 2025 21:49:31 GMT

I'm having trouble creating a pane for a help desk that shows when a host goes down. The problem I seem to be running into is that when a host goes down for something like a power failure, the agent stops reporting, and there is no data to indicate a "down" status, which seems to "remove" it from dashboards. Ultimately, when a host changes its availability state to something other than "up," I would like it to appear in a table until it's back "up". Thanks!

Re: Host Availability Dashboard Pane

p_devulapalli — Tue, 29 Apr 2025 05:25:11 GMT

@m_laurie_az There are a few ways to get around this issue , if you want to report some data when "no data" is being reported , you can use the nonempty parameter in DQL.

See below link for some details around the usage

https://community.dynatrace.com/t5/Open-Q-A/Host-availability-state-metric-of-no-data/m-p/270961

Alternatively, you can also report the Availability data in % in a table and list least available servers. Any drop in availability will be reported less than 100%. Here is a example DQL

fetch dt.entity.host | fieldsAdd tags | filter in(tags, "TIER:PRIORITY") | filterOut isMonitoringCandidate == true or standalone == true | lookup [ timeseries m1=max(dt.host.availability, rollup: sum), filter:availability.state == "up", by:{availability.state,dt.entity.host},from: toTimestamp($dt_timeframe_from), to: toTimestamp($dt_timeframe_to)-2m | parse replaceString(toString(m1),"null","0"), """'['ARRAY{ DOUBLE:i ', '}{1,10000}:m1Pop""" | fieldsAdd intervalToMinutes = toLong(interval)/60000000000 | fieldsAdd availability= toDouble(arraySum(m1Pop)/(arraySize(m1Pop))*100)/intervalToMinutes], sourceField: id, lookupField: dt.entity.host, fields: {availability} | fields dt.entity.host = id, Host=entity.name,`Availability %`=coalesce(availability, 0) | sort `Availability %` asc | limit 10

topic Host Availability Dashboard Pane in DQL

Host Availability Dashboard Pane

Re: Host Availability Dashboard Pane