topic Re: field extraction help in Splunk Search

field extraction help

hello_world15 — Wed, 23 May 2012 08:10:34 GMT

Hi All,

I am a newbie on splunk and I have the following events:

IF-MIB::ifInOctets.502 = Counter32: 675328773

IF-MIB::ifInOctets.501 = Counter32: 407638105

And would like to extract the info like this.
key=ifInOctets.502, value=675328773
key=ifInOctets.501, value=407638105

what should I configure in transforms.conf? Thanks for your help.

Re: field extraction help

Ayn — Wed, 23 May 2012 08:37:16 GMT

Assuming that the leading "IF-MIB::" and the string "Counter32:" are constant for all events you want to extract this from, put something like this in transforms.conf:

[extract_snmp]
REGEX = IF-MIB::(\S+) = Counter32: (\d+)
FORMAT = $1::$2

Then refer to it like this in props.conf:

[yoursourcetype]
REPORT-snmpextract = extract_snmp

Re: field extraction help

hello_world15 — Fri, 25 May 2012 03:59:43 GMT

Thanks alot.

One stupid question: how can I modify the REGEX to match this also.

IF-MIB::ifDescr.501 = STRING: ge-0/0/0

Thanks alot.

Re: field extraction help

Ayn — Fri, 25 May 2012 05:57:28 GMT

Something like this should work (and be more generic):

IF-MIB::(\S+) = [^:]+: (\S+)

Re: field extraction help

hello_world15 — Fri, 25 May 2012 08:26:38 GMT

Thanks alot.

Re: field extraction help

Ayn — Fri, 25 May 2012 08:36:09 GMT

No problem. Could you please mark my answer as accepted if this solved your issue? Thanks!