Splunk Enterprise

How to write time format for 2022-04-07 20:40:03.360 -06:00 [XXX] XXXXX?

Hemnaath
Motivator

How to write time format for the below  event log 

2022-04-07 20:40:03.360 -06:00 [XXX] Hosting starting.
2022-04-07 20:40:03.474 -06:00 [XXX] Hosting starting.
2022-04-07 20:40:03.493 -06:00 [XXX] Hosting starting.

Getting Could not use strptime to parse the time stamp from 2022-04-07 20:40:03.360 -06:00

[Sourcetype]

SHOULD_LINEMERGE=false
LINE_BREAKER=([\r\n]+)\d+\-\d+\-\d+\s\d+\:\d+\d:\d+\.\d+\s+[^\]]+\]
NO_BINARY_CHECK=true
disabled=false
TIME_PREFIX=^
TIME_FORMAT=%Y/%m/%d %H:%M:%S.%3N %z   
MAX_TIMESTAMP_LOOKAHEAD=31

Kindly guide me to fix this time stamp issue.

Labels (2)
Tags (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

You're close, but the given string doesn't use the same separators as the data.  Also, a time zone with embedded ":" needs a different format character.  Try this:

TIME_FORMAT=%Y-%m-%d %H:%M:%S.%3N %:z

   

---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

You're close, but the given string doesn't use the same separators as the data.  Also, a time zone with embedded ":" needs a different format character.  Try this:

TIME_FORMAT=%Y-%m-%d %H:%M:%S.%3N %:z

   

---
If this reply helps you, Karma would be appreciated.
0 Karma

Hemnaath
Motivator

thanks, It fixed the error.

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

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

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...