Splunk Search
Highlighted

How to handle events where the same field occurs multiple times?

Motivator

Hey,

I have some data that looks like this:

Jan 01 01:02:03 host123 serial123 Version=1.0, Check=01 , Check=02 , Check=03 , Check=04 , Check=05 , Server=ABC, Server=DEF

Splunk is currently only extracting the first occurrence of field Check (i.e. 01) and field Server (i.e. ABC) by default.
What do I need to add to the Splunk config to force all occurrences of these fields to be extracted?

Thanks

0 Karma
Highlighted

Re: How to handle events where the same field occurs multiple times?

SplunkTrust
SplunkTrust

How are extracting the fields now?

---
If this reply helps you, an upvote would be appreciated.
0 Karma
Highlighted

Re: How to handle events where the same field occurs multiple times?

Motivator

Splunk extracts the first occurrence only by default. What I am expecting is for the field "Check" to be assigned values 01, 02, 03, 04 and 05

0 Karma
Highlighted

Re: How to handle events where the same field occurs multiple times?

SplunkTrust
SplunkTrust

You can do this through field transformations with the multivalue checkbox checked:
http://docs.splunk.com/Documentation/Splunk/latest/Knowledge/Managefieldtransforms

0 Karma
Highlighted

Re: How to handle events where the same field occurs multiple times?

Motivator

Hi, thanks for this but it is not what I am looking for. I want the fields "Check" and "Server" to be assigned all of the fields in the event without having to use any additional search commands. Is there Splunk config which will force this to happen?

0 Karma
Highlighted

Re: How to handle events where the same field occurs multiple times?

SplunkTrust
SplunkTrust

Looks like I got the wrong link, fixed... that's config only.

0 Karma
Highlighted

Re: How to handle events where the same field occurs multiple times?

Motivator

http://docs.splunk.com/Documentation/Splunk/latest/Knowledge/Createandmaintainsearch-timefieldextrac...

The section titled Handling events with multivalue fields seems to be what I am looking for. The below does what I need.

In transforms.conf:

[mv-check]
REGEX = Check=(?<Check>\d+)[,\s]+
MV_ADD = true

In props.conf:

REPORT-mychecks = mv-check

View solution in original post

0 Karma