Splunk Search

Identify a sequence of events on the consecutive change of value of a field

vburgun
Engager

Hi


We index the accesses made on a filer. For each action on a file, events are generated and indexed in Splunk.


The copy of a file does not directly generate a "copy" event but the "Event.System.EventName" field consecutively takes the three values "Open Object", "Get Object Attributes", "Read Object".

This corresponds to three events in Splunk with no real common fields. How to build a query that would identify this consecutive sequence of events to alert us of a file copy ?

Maybe the streamstat command could be used but I can't figure out how.

0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Try something like this

| streamstats window=3 list(event) as last3events
| eval last3events=mvjoin(last3events,",")
| where last3events == "Open,Get,Read"

Depending on the order of events for your initial search, you may either need to sort them, or look for "Read,Get,Open"

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

Try something like this

| streamstats window=3 list(event) as last3events
| eval last3events=mvjoin(last3events,",")
| where last3events == "Open,Get,Read"

Depending on the order of events for your initial search, you may either need to sort them, or look for "Read,Get,Open"

vburgun
Engager

Hi,

Thanks for your help ! It's perfect !

It works for me

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...