Hi all, I've a csv file with 3 columns ip, earliest, latest and over 400 rows. I'm trying to return all evens associated with the IP for an hour before and after the interesting request time. The search below works for a single row but I can't figure out how treat each row as a unique search and compile the results at the end.
What appears to happen when I upload multiple rows in the csv is the search will run for all interesting IPs from the earliest earliest value to the latest latest value. It kind of meets the intent but is very wasteful as the index is huge and the times span several years with days/months between them.
Is what I'm trying to achieve possible?
index=myindex client_ip_address earliest latest
[| inputlookup ip_list_2.csv
| eval ip = "*" . 'Extracted IP' . "*"
| eval earliest=strptime('REQUEST_TIME', "%m/%d/%y %H:%M")-(60*60)
| eval latest=strptime('REQUEST_TIME', "%m/%d/%y %H:%M")+(60*60)
| fields ip earliest latest
]
... View more