I did not know that 😉 With your suggestion I did get a single row but the 0 values where in there as well. Replaced them with isnull and now I only have values and a single two per server. | stats latest(Value) as Value by host, counter
| eval "CPU Time" = if(counter="% Processor Time",Value,isnull)
| eval "RAM Available" = if(counter="Available MBytes",Value,isnull)
| eval "C Free Space" = if(counter="% Free Space",Value,isnull)
| stats Values(*) as * by host
| table host, "CPU Time", "RAM Available", "C Free Space" Thanks
... View more