Hi,
I'm using a lookup table with approx 107,000 lines and 6MB in size. Trying to display a list of hosts which are in a lookup table, but not in the Splunk events. The below search seems to work, but not effectively. The results display 96,648. I'm expecting more around 50,000. When I search a host which is in the results, it is contained in the Splunk events which validates it's not effective. Any idea whether there are limits on size of lookup tables?
| inputlookup workstations | rename fielda AS fieldb | dedup fieldb | search NOT [search index=index-name | dedup fieldb | fields fieldb]
... View more