Splunk Search

How to set the the correct timestamp recognition and formatting in props.conf?

LuiesCui
Communicator

Hey guys, I'm new to splunk and I need ur help!!!

A .log file is loaded by forwarder to Splunk and is setting the wrong timestamp like this:

Actual time

15/03/03 23:59:43.000
Events

Mon,02Mar 23:59:43 Flow Control Request counter: [1]

So I tried to set the timestamp by editing the props.conf, like this:

[palink_log]
CHARSET = CN-GB
NO_BINARY_CHECK = true
priority = 1
TIME_PREFIX = \w{3},
TIME_FORMAT = %d%b %H:%M:%S

It doesn't help and there's no year data in events. How do I set the the correct timestamp manually for this single file?

0 Karma
1 Solution

srinathd
Contributor

Try this TIME_FORMAT=%a,%d%b %H:%M:%S

View solution in original post

0 Karma

srinathd
Contributor

Try this TIME_FORMAT=%a,%d%b %H:%M:%S

0 Karma

cpetterborg
SplunkTrust
SplunkTrust

If you do, get rid of the TIME_PREFIX, as it will conflict with the parsing of the time.

0 Karma

LuiesCui
Communicator

And how do I set year?

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...