I am trying to build a query to monitor the IOCs in the lookup which has the time field in it.
Attached the screenshot.
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.
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
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.
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.