Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Re: STATS function
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, Is there a way to find out the max response time during a 30-minute bucket and its associated url from the web server log?
I tried to use the search string below but seems to be not working. Please advise. Thanks!
sourcetype="access_log" | bucket _time span=30m | STATS max(TotalResponseTime), url by _time
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use eventstats to preserve the url and then grab only those urls where the response time equals the max. If there are multiple urls with the same TotalResponseTime, then you could still get multiple urls for the same time range, but that would seem unlikely.
sourcetype="access_log" | bucket _time span=30m | eventstats max(TotalResponseTime) as maxtim by _time | where TotalResponseTime=maxtim |table _time,TotalResponseTime,url
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use eventstats to preserve the url and then grab only those urls where the response time equals the max. If there are multiple urls with the same TotalResponseTime, then you could still get multiple urls for the same time range, but that would seem unlikely.
sourcetype="access_log" | bucket _time span=30m | eventstats max(TotalResponseTime) as maxtim by _time | where TotalResponseTime=maxtim |table _time,TotalResponseTime,url
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Does .... STATS max(TotalResponseTime) by _time url work for you?
I think its trying to use 'url' as an argument?
Br
Dave S
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Unfortunately, this is not something I need. I only care about the url with max response time.
I have various types of urls in the web access log. If I add the url at the end of the search string, I will have too many results.
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Splunk Add-on for Microsoft Windows 11.0.3: Parse Once, Search Faster
What's New in Splunk Enterprise Security 8.8 and Beyond
A Four-Part Event Series: State of Observability - Where AI Meets Performance
