Splunk Enterprise Security

How to delete rows in lookup based on time or date

KumarGB
Explorer

Hi,

I am trying to build a query to monitor the IOCs in the lookup which has the time field in it.

Attached the screenshot.alt text

Based on the time field the rows should be automatically deleted. For example: the rows meets the condition "_time < 7 Oct 2019" should be deleted.

Do anyone have an idea on how to create saved search to delete the rows based on the condition.

1 Solution

jkat54
SplunkTrust
SplunkTrust

If you can write a search that produces all the other rows excluding what you want to delete, then you can just | outputlookup your_lookup

View solution in original post

0 Karma

jkat54
SplunkTrust
SplunkTrust

If you can write a search that produces all the other rows excluding what you want to delete, then you can just | outputlookup your_lookup

0 Karma

KumarGB
Explorer

Thanks!! It helped.

the below eval command was not giving a correct value

| eval 60dAgo=now()-(86400*60)

so I changed as below

| eval dif=(now()-TIME)/86400
| where dif <= 60

jkat54
SplunkTrust
SplunkTrust

Nice work adapting my example for your needs!

0 Karma

KumarGB
Explorer

I will be keep on adding IOCs on weekly basis.. I don't want the IOCs which are older than 60 days. So it should be deleted automatically from this lookup using the saved search.

0 Karma

jkat54
SplunkTrust
SplunkTrust

Yes thats what I'm saying...

| inputlookup append=true your_lookup 
| eval TIME=strptime(_time,"%m/%d/%Y")
| eval 60dAgo=now()-(86400*60)
| where TIME<60dAgo
| outputlookup your_lookup

Run it for all time however often you like.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...