topic Re: Can you remove multiple entries from a lookup table using a search? in Splunk Search

Can you remove multiple entries from a lookup table using a search?

mark_cet — Wed, 01 Feb 2023 18:44:36 GMT

Hi,

I have a lookup table that contains a list of sessions with permitted time frames (start day & time / end day & time). I am looking for a way to run a scheduled search to remove any expired entries from the lookup table (e.g. sessions with end days / times that have passed).

Can multiple entries be removed from a lookup table via a search? I know I can append to a lookup table but not sure about deletion.

Thanks!

Re: Can you remove multiple entries from a lookup table using a search?

isoutamo — Wed, 01 Feb 2023 18:54:23 GMT

basically you create a scheduled search which will do it. Here is one example from community

https://community.splunk.com/t5/Splunk-Search/Updating-fields-in-a-lookup-through-a-scheduled-search/m-p/215996

read old with inputlookup
append it to your normal seach
filter out unwanted entries
store it back to lookup file with outputlookup
1. Be sure that in problem situations you don't get empty file!

r. Ismo

Re: Can you remove multiple entries from a lookup table using a search?

mark_cet — Sat, 04 Feb 2023 14:22:14 GMT

Thank you very much for this isoutamo! I will give it a try.