Home🧪 DQL RecipesModule 11 min read · 2/10

Host Health Recipes

Hands-on

Host Health Recipes

CPU Usage by Host

timeseries avg(dt.host.cpu.usage), by:{dt.entity.host}

Memory Usage by Host

timeseries avg(dt.host.memory.usage), by:{dt.entity.host}

Disk Usage by Host

timeseries avg(dt.host.disk.used.percent), by:{dt.entity.host}

Host Overview Table

fetch dt.entity.host
| fields entity.name, monitoringMode, state, tags, osType

Top CPU Consumers (Current)

timeseries cpu = avg(dt.host.cpu.usage, scalar:true), by:{dt.entity.host}
| fieldsAdd current = arrayLast(cpu)
| sort current desc
| fields dt.entity.host, current

Hosts with High CPU (> 80%)

timeseries cpu = avg(dt.host.cpu.usage, scalar:true), by:{dt.entity.host}
| fieldsAdd current = arrayLast(cpu)
| filter current > 80
| fields dt.entity.host, current

Process Groups on a Host

fetch dt.entity.process_group
| expand runs_on
| fields entity.name, softwareTechnologies, runs_on
| limit 20

Multi-Metric Host Dashboard

timeseries {
  cpu = avg(dt.host.cpu.usage),
  mem = avg(dt.host.memory.usage),
  disk = avg(dt.host.disk.used.percent)
}, by:{dt.entity.host}

💡 Copy any of these into a Dashboard tile. timeseries queries auto-render as line charts, fetch queries as tables.

🛠 Try it: Open a Notebook → paste each query from this page one by one. Change the time range to from:now()-7d to see weekly trends. Try adding | filter entity.name == "YOUR-HOST" to focus on a specific host.