Splunk Search

How do I find the "Event" that directly proceeds the selected "Event"?

philrego
Path Finder

Let's say I perform this search:

index=mysecretindex host=mysecrethost*  source="/my.log" error-3005

Then say I select an "event".
How do I find the "event" that directly precedes (ordered by time) the selected "event"?

0 Karma
1 Solution

philrego
Path Finder

You can't. If you want to see the event that directly precedes the event you will need to remove all your filters and manually look through the rows one by one. It can take hours but it's the only way if you want to use Splunk.

View solution in original post

0 Karma

philrego
Path Finder

You can't. If you want to see the event that directly precedes the event you will need to remove all your filters and manually look through the rows one by one. It can take hours but it's the only way if you want to use Splunk.

0 Karma

nabeel652
Builder

From what I have understood, this example may help you with some modifications:

index=_internal sourcetype=splunkd_access | streamstats count | table _raw count | eval selected_event = 5 | where count>=selected_event | head 2
0 Karma

philrego
Path Finder

I'm not going to enter that huge line just when I want to see the preceding event. That doesn't even do anything close to what I've asked. Please delete.

0 Karma

nabeel652
Builder

What do you mean by select? How are you selecting the event?

0 Karma

philrego
Path Finder

Click on. By clicking

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

REGISTER NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If ...

Observability | Use Synthetic Monitoring for Website Metadata Verification

If you are on Splunk Observability Cloud, you may already have Synthetic Monitoringin your observability ...

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...