Splunk Search

Efficient filtering with high number of values from a lookup table

Simon
Contributor

Hi all,

I've got 16k and growing values in a CSV. I'd like to search for events matching those values, like

tag::eventtype="authentication" [| inputlookup cmdb_former_employees | fields user | return 999999 user ]

But it seems that this is pretty much inefficient and results in a very slow search.
Is there a better way to find events matching a large set of values form a lookup?

Thanks,
Simon

Tags (3)
0 Karma

starcher
Influencer

I'd try making that an auto lookup for the relevant sourcetypes.

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...