Getting Data In

How to extract the Fields from .txt file

pbsuju
Explorer

I am indexing Server.txt file from 1000+ forwarders. The file format is as below. I want to extract below header values as field while indexing it. Could someone please suggest what need to be added in props.conf of indexer to extract these fields. I am using splunk version of 6.4
ServerName,OSVersion,Make,Uptime,LastReboot (Fields to be extracted)

ServerName,OSVersion,Make,Uptime,LastReboot
Server1,Windows2008 R2,23hrs,10/10/2017
Server2,Windows2012 R2,13hrs,11/12/2107
Server3,Windows2012 R2,13hrs,11/11/2017

Tags (1)
0 Karma
1 Solution

mtulett_splunk
Splunk Employee
Splunk Employee

Since your data is already in CSV format, you can enable CSV extraction using the header row as the field names. Your props.conf should look like this:

[ csv_custom ]
DATETIME_CONFIG=NONE
INDEXED_EXTRACTIONS=csv
FIELD_DELIMITER=,

Note: You will need to distribute this config to the universal forwarders as well, since they need the configuration to correctly read the CSV file. Are you doing this, or are you only placing the config on the indexer?

This config appears to work correctly for me (I added the missing make field into the data):

CSV Extraction

View solution in original post

0 Karma

pbsuju
Explorer

I already have below in props.conf of indexer . But I don't see fields getting extracted.

[server_Input]
INDEXED_EXTRACTIONS = CSV
FIELD_DELIMITER = ,
FIELD_QUOTE = NONE
HEADER_FIELD_LINE_NUMBER = 1
DATETIME_CONFIG = NONE
CHECK_METHOD = modtime

0 Karma

mtulett_splunk
Splunk Employee
Splunk Employee

I've updated my answer slightly.

0 Karma

mtulett_splunk
Splunk Employee
Splunk Employee

Since your data is already in CSV format, you can enable CSV extraction using the header row as the field names. Your props.conf should look like this:

[ csv_custom ]
DATETIME_CONFIG=NONE
INDEXED_EXTRACTIONS=csv
FIELD_DELIMITER=,

Note: You will need to distribute this config to the universal forwarders as well, since they need the configuration to correctly read the CSV file. Are you doing this, or are you only placing the config on the indexer?

This config appears to work correctly for me (I added the missing make field into the data):

CSV Extraction

0 Karma

pbsuju
Explorer

Thanks. It worked.

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!

Where Innovation Takes Flight: The Splunk4Aviation Flight Sim Lands at .conf26

If you hear someone at .conf26 shouting "gear down, GEAR DOWN" across the show floor, you have found us.  The ...

Turn Cisco Telemetry Into Action with Cisco Data Fabric, powered by the Splunk ...

The surge in machine data is already hitting enterprise budgets, and the agentic era will only intensify it. ...

Persistent Queue at TcpOut — One of Splunk's Most Practical Features

Splunk introduced persistent queueing at the tcpout layer as one of the most practical resilience features in ...