Getting Data In

time stamp including day of the week

smudge797
Path Finder

Splunk is struggling with this log format. any advise on how to get splunk to read the time stamp with day of the week included?:

Thu Mar 06 08:08:07 PST 2014 LogSource=SERVICE ExperimentId=2897 MessageCount=1
Thu Mar 06 08:08:07 PST 2014 LogSource=SERVICE ExperimentId=3112 MessageCount=4
Thu Mar 06 08:08:07 PST 2014 LogSource=SERVICE ExperimentId=3391 MessageCount=2
Thu Mar 06 08:08:07 PST 2014 LogSource=SERVICE ExperimentId=3594 MessageCount=7
Thu Mar 06 08:08:07 PST 2014 LogSource=SERVICE ExperimentId=2634 MessageCount=406

Tags (1)
0 Karma

somesoni2
Revered Legend

Splunk should be able to parse the timestamp without Weekday part. To do parsing including, specify Timestmap format while import or in props.conf.

[yoursourcetype]
TIME_FORMAT = %a %b %d %H:%M:%S %Z %Y
.
.
0 Karma

linu1988
Champion

whats the issue in this, it's pretty straight forward for splunk, reading it properly with the timezone as well.

0 Karma

lukejadamec
Super Champion

Splunk does not need the day of the week in text, because it is there in number. Have you tried specifying a TIME_FORMAT without it?
%B %d %H:%M:%S %Z %Y

Get Updates on the Splunk Community!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...