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

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

Hemnaath — Thu, 14 Apr 2022 16:24:57 GMT

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.

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

richgalloway — Thu, 14 Apr 2022 16:43:39 GMT

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

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

Hemnaath — Sun, 17 Apr 2022 02:18:49 GMT

thanks, It fixed the error.