topic Inline field extraction with rex in Splunk Search

Inline field extraction with rex

lukejadamec — Sat, 12 Oct 2013 00:43:26 GMT

I'm not a big regex power yet, I know this is easy, but since it is not on a system I can't test and figure out myself I'm looking for expert assistance.
Can someone provide a search rex that will pull both the interface and up-down fields from this log?

Oct  9 12:01:18 hos-a-3550-1.rockefeller.internal 2635634: Oct  9 12:01:17: %LINEPROTO-5-UPDOWN: Line protocol on Interface FastEthernet0/3, changed state to down
Oct  9 12:01:18 hos-a-3550-1.rockefeller.internal 2635634: Oct  9 12:01:17: %LINEPROTO-5-UPDOWN: Line protocol on Interface FastEthernet0/3, changed state to up

Looking for a rex that pulls two fields:

search | rex field=_raw ?(?<interface>?)?(?<up-down>?)? | stats count by interface,up-down

Thanks,

Luke

Re: Inline field extraction with rex

yannK — Sat, 12 Oct 2013 04:56:49 GMT

please show that you are looking for precisely.

Re: Inline field extraction with rex

yannK — Sat, 12 Oct 2013 16:20:13 GMT

Here

mysearch | rex "Interface (?<interface>[^, ]*), changed state to (?<state>\w+)" | table interface state

Re: Inline field extraction with rex

lukejadamec — Sat, 12 Oct 2013 17:03:43 GMT

Thanks. I totally need to learn regex.

Re: Inline field extraction with rex

yannK — Mon, 14 Oct 2013 16:44:40 GMT

here is a good place to start
http://www.regular-expressions.info/quickstart.html