Getting Data In

Simple field extraction with data index from /var/spool/splunk

tkropp
Path Finder

Not working......

I'm testing field extractions on some new logs. I created simple regex to extract server names from the logs, and used REPORTS in transforms. The field extraction is not working at search time. validated with rex.

| rex field=_raw "(?<servername> [a-z][a-z]-[a-z][a-z][a-z][0-9][0-9])"


-rw------- 1 root   root    75 Apr 12 20:51 props.conf
-rw-r--r-- 1 root   root   111 Apr 12 19:50 transforms.conf
[root@id-spk01 local]# pwd
/opt/splunk/etc/system/local

--------------------------------
#props

[sourcetype::CoreLogs]
REPORT-servername = core_server_name

#transforms

[core_server_name]
REGEX = ([a-z][a-z]-[a-z][a-z][a-z][0-9][0-9])
FORMAT = core_server_name::"$1"
Tags (2)
0 Karma
1 Solution

gkanapathy
Splunk Employee
Splunk Employee

You shouldn't have

[sourcetype::whatever]

but just

[whatever]

Also, omit the quotes from around $1, i.e. fieldname::$1 instead of fieldname::"$1".

View solution in original post

gkanapathy
Splunk Employee
Splunk Employee

You shouldn't have

[sourcetype::whatever]

but just

[whatever]

Also, omit the quotes from around $1, i.e. fieldname::$1 instead of fieldname::"$1".

jrodman
Splunk Employee
Splunk Employee

IN addition, your rex command is trying to capture a space, while your extraction is not trying to capture a space. I'm not sure if you want one or not. If you do, that would probably be REGEX = \s([a-z][a-z]-[a-z][a-z][a-z][0-9][0-9])

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...