Splunk App for Unix and Linux: How to correlate the top 10 CPU utilizing Linux hosts and the top 1 process in each of them?

[skasasa]

I'd like help on a search to correlate the top 10 CPU utilizing Hosts and the top 1 process in each of them. These are Linux servers and I've already installed Splunk App for Unix and Linux.

[renjith_nair]

Try this

index=os sourcetype=df |stats avg(<CPU FIELD> as AvgCPU by host,<process field>|sort 0 -Host,-AvgCPU |streamstats count as row by Host|where row==1