Hi shreyasathavale,
Sure, the lazy and not very well performing way would be this:
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, earliest, latest
| map search=" search (earliest=$earliest$ latest=$latest$+3600) index=perfmon host=web1 (counter="% Processor Time" OR counter="Get Requests/Sec" OR counter="Current Connections")
|stats avg(Value) by host, counter
This is completely untested and keep in mind, for me it's early Monday morning 🙂
I'm pretty sure this can be done with some stats tricks
Hope that helps ...
cheers, MuS
... View more