Getting Data In

wrong event timestamp

SplunkCSIT
Communicator

After the data is forwarded to indexer, the date format for event seems to be incorrect for some events (whereby the day and month is less than 12) and correct for the rest (the day is more than 12), how come and what will be the remedy? The event timestamp is taken from the timestamp found inside the content of the data.

Correct timestamps:
02/03/2014
(dd/mm/yyyy)

14/03/2014
(dd/mm/yyyy)

incorrect timestamp:
02/03/2014
(mm/dd/yyyy)

Tags (1)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Specify a TIME_FORMAT in your props.conf to tell Splunk the order of month and day fields explicitly.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Do post your config so we can take a look.

0 Karma

SplunkCSIT
Communicator

also the same, it happened for only two dates, 1Mar and 2Mar, it recognise as 3Jan, 3Feb, the rest of the dates, it able to get the correct date format.

0 Karma

linu1988
Champion

you need to set props.conf in indexer not forwarder..

0 Karma

SplunkCSIT
Communicator

already set that in forwarder props.conf but date format for event seems to be incorrect for some events (whereby the day and month is less than 12) and correct for the rest (the day is more than 12). Any other suggestion?

0 Karma
Get Updates on the Splunk Community!

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

Splunk Up Your Game: Why It's Time to Embrace Python 3.9+ and OpenSSL 3.0

Did you know that for Splunk Enterprise 9.4, Python 3.9 is the default interpreter? This shift is not just a ...