topic Re: Regexing multiple values in Splunk Search

Regexing multiple values

WestlyB — Wed, 23 Mar 2016 03:34:11 GMT

Hello everyone,

I've been banging my head on this one. I'm sure it involves 'rex' which I'm not so familiar with.

I have the following search
search | regex _raw="|MAX TCP Connections||MAX UDP Connections|" | table _raw

Of course this spits out the entire _raw event. I'd like search for all events that match event with either MAX TCP Connection or MAX UDP Connection and send those to a field and when I use table, I see either MAX TCP Connections or MAX UDP Connections in the field. No event will have both. I really hope that makes sense. Any help would be great.

Re: Regexing multiple values

the_wolverine — Wed, 23 Mar 2016 04:57:13 GMT

"MAX TCP Connections" OR "MAX UDP Connections" | rex "(?<value>(MAX TCP Connections|MAX UDP Connections)" | stats count by value

Re: Regexing multiple values

WestlyB — Wed, 23 Mar 2016 05:47:52 GMT

Thanks for the reply! but this didn't work for me. 😞

Re: Regexing multiple values

the_wolverine — Wed, 23 Mar 2016 07:05:30 GMT

The match is case sensitive so edit as needed to exact match the string you are looking for.

Re: Regexing multiple values

MuS — Wed, 23 Mar 2016 07:15:26 GMT

Maybe add a max_match=0 to the regex or to make it case insensitive add (?i) to the regex like this rex "(?<value>(?i)(MAX TCP Connections|MAX UDP Connections)" and remember - this is un-tested since I have no Splunk instance handy right now 😉

Re: Regexing multiple values

somesoni2 — Wed, 23 Mar 2016 14:13:59 GMT

Please provide some sample data and expected final output.