Getting Data In

Finding where multiple events have the same time

mikelanghorst
Motivator

We had an issue here with one of our web fronted applications when the webserver received multiple requests to the same url down to the same millisecond. This caused the wrong file to be delivered to the first requestor. Obviously this was an issue with the code to allow the problem, but I couldn't think of how to find occurrences of this.

So for a given source, how to show where 2 or more events occur at the same time?

Tags (1)
1 Solution

RicoSuave
Builder
<yoursearch> | transaction _time | where eventcount > 1

View solution in original post

ziegfried
Influencer

Just an alternative that might be a bit more efficient:

... | eventstats count by _time | where count>0
0 Karma

RicoSuave
Builder
<yoursearch> | transaction _time | where eventcount > 1

mikelanghorst
Motivator

Thanks, hadn't thought of using transaction. A bit more filtering and this will work great. Just that one step took the results from 5k, down to 342 results.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Preparing your Splunk Environment for OpenSSL3

The Splunk platform will transition to OpenSSL version 3 in a future release. Actions are required to prepare ...

Self-Healing Pipeline Is Now Generally Available: AI-Powered CIM Compliance

Maintaining data integrity across security and analytics pipelines is an ongoing challenge. Data ...

[Puzzles] Solve, Learn, Repeat: Family Trees

This puzzle (first published here is based on finding grandparents and grandchildren (inspired by a question ...