My 1st search will be like this to get Peak Day and Peak Hour according to hits:
earliest="06/08/2015:00:00" latest="06/14/2015:23:59" index=iis | stats count as hit by date_hour, date_mday
| eventstats max(hit) as maxhit by date_mday
| where hit=maxhit| sort hit desc|top limit=1 hit,date_mday,date_hour|fields date_hour,date_mday,hit
Now after getting peak day and peak hour from the 1st result, using this peak day and peak hour, I want to run the search below:
(earliest="result from above" latest="result of peak hour+1hr") index=perfmon host=web1 (counter="% Processor Time" OR counter="Get Requests/Sec" OR counter="Current Connections") |stats avg(Value) by host, counter
Result should show Peak Hour, Peak Day, avg(Value), counter
I have spent almost 2 days on this.
Is it possible?
... View more