Getting Data In

What do we need to write in TIME_FORMAT in props.conft to extract a timestamp?

vishaltaneja070
Motivator

How do you extract a timestamp in an event like this "2018-12-05T00:31:03.711Z"?

Like, what do we need to write in TIME_FORMAT in props.conf?

Tags (1)
0 Karma
1 Solution

prakash007
Builder

Hope this should work..

[<sourcetype>]
SHOULD_LINEMERGE = false
TIME_PREFIX = ^\"
TIME_FORMAT = %Y-%m-%dT%H:%M:%S.%3N%Z
MAX_TIMESTAMP_LOOKAHEAD = 25

View solution in original post

whrg
Motivator

Hi @vishaltaneja07011993! Can you post one whole event? Because it matters where the timestamp is situated in the event and you might need to configure TIME_PREFIX accordingly.

0 Karma

skoelpin
SplunkTrust
SplunkTrust

I think you're asking how Splunk identifies the timestamp in the raw logs rather than how Splunk extracts it

0 Karma

prakash007
Builder

Hope this should work..

[<sourcetype>]
SHOULD_LINEMERGE = false
TIME_PREFIX = ^\"
TIME_FORMAT = %Y-%m-%dT%H:%M:%S.%3N%Z
MAX_TIMESTAMP_LOOKAHEAD = 25

bjoernjensen
Contributor

Hey,

Splunk should handle that automatically:

alt text

What exactly is not working at your side?

0 Karma

woodcock
Esteemed Legend

No, no, no! Never, EVER let Splunk do anything related to timestamping or sourcetyping automatically!

skoelpin
SplunkTrust
SplunkTrust

Correct. ALWAYS explicitly tell Splunk how to line break and timestamp

Get Updates on the Splunk Community!

Synthetic Monitoring: Not your Grandma’s Polyester! Tech Talk: DevOps Edition

Register today and join TekStream on Tuesday, February 28 at 11am PT/2pm ET for a demonstration of Splunk ...

Instrumenting Java Websocket Messaging

Instrumenting Java Websocket MessagingThis article is a code-based discussion of passing OpenTelemetry trace ...

Announcing General Availability of Splunk Incident Intelligence!

Digital transformation is real! Across industries, companies big and small are going through rapid digital ...