How can I calculate per host CPU utilization in a report?

[JyotiP]

host=test01 index="perfmon" collection="CPU" counter="% Processor Time" | bucket _time span=15m | stats avg(Value) as avg_CPU by _time | where avg_CPU>=60

The above query is giving me the CPU utilization above 60% with the span of 15 minute. But I have 9 host like aeperf01,aeperf02,aeperf03 and so on. I want to calculate per host how can I do it ??

[richgalloway]

Try something like this. It will show the current Value for each host.

host=aeperf* index="perfmon" collection="CPU" counter="% Processor Time" | bucket _time span=15m | stats avg(Value) as avg_CPU by host | where avg_CPU>=60

If you want to see the Value over time, try this.

host=aeperf* index="perfmon" collection="CPU" counter="% Processor Time" | bucket _time span=15m | timechar avg(Value) as avg_CPU by host | where avg_CPU>=60