Splunk Search

Getting value from more than one event ago

TBo123
Path Finder

Hello again,

here is my search result:

_time ID1 ID2
1.1.09 30122 1
1.1.09 30122 1
1.1.09 30127 2
1.1.09 30128 2
1.1.09 30129 2
1.1.09 30129 2
1.1.09 30130 3
1.1.09 30131 3

I'd like to have something like this:

_time ID1 ID2
1.1.09 30122 1
1.1.09 30122 1
1.1.09 30127 2
1.1.09 30127 2
1.1.09 30127 2
1.1.09 30127 2
1.1.09 30130 3
1.1.09 30130 3

ID2 shows when ID1 should change the value. All events that have the same ID2 should get the first value from ID1 for that group.

I hope someone can help me.

Thanks.

Tags (1)
0 Karma
1 Solution

strive
Influencer

I created a CSV using your first resultset and tested it.

Try this

Your search terms... | eventstats first(ID1) as temp_id1 by ID2 | fields - ID1 | rename temp_id1 as ID1

View solution in original post

strive
Influencer

I created a CSV using your first resultset and tested it.

Try this

Your search terms... | eventstats first(ID1) as temp_id1 by ID2 | fields - ID1 | rename temp_id1 as ID1

TBo123
Path Finder

thank you, that is exactly what I am looking for, great..

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...