topic Re: Lookup table with several IP ranges per row in Splunk Search

Lookup table with several IP ranges per row

pgomezji — Mon, 14 Dec 2020 10:47:39 GMT

Hi, I have a lookup table with IP ranges and locations. The problem is in the IP range column there can be several IP ranges separated by comma. How can match the client IP address with the right location?

Re: Lookup table with several IP ranges per row

nickhills — Mon, 14 Dec 2020 11:15:49 GMT

To use a CIDR match you need each row in the lookup to have a single row per CIDR block.

So if your lookup has comma separated CIDR blocks you need to split these into rows.

You can either do this by manually splitting the data and adding rows, or you could use |inputlookup, split the field, then mvexpand and re-write the (or create a new) lookup.

replace the first 3 lines with |inputlookup yourfile.csv
add at the end |outputlookup yourNewfile.csv to write a new file

| inputlookup yourfile.csv | eval cidr=split(cidr,",")|mvexpand cidr | outputlookup yourNewfile.csv

Re: Lookup table with several IP ranges per row

pgomezji — Fri, 18 Dec 2020 14:12:12 GMT

Thanks, I was afraid of that answer.