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!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...