Getting Data In

Why is my timestamp not being recognized...

a212830
Champion

Hi,

I have the following data coming in:

10009 SYSTEM 03/05/17 11:12:44 Info Message Partner MQCACTUSOUT, Session 611 - Message sent
    Sequence number : 242034
    UUMID           : OCHASUS33XXX9002556093123JY    
    Suffix          : 1705031356750
 - lrtAZ842

The problem is, instead of interpresting the date as May 3rd, it's being interpreted as March 5th. My props has the following, which looks correct to me.

[swift_alarmsmsgs]
SHOULD_LINEMERGE=false
NO_BINARY_CHECK=true
ANNOTATE_PUNCT=false
KV_MODE=auto
LINE_BREAKER = ([\r\n]+)\d{5}
TIME_FORMAT = %d/%m/%y %H:%M:%S
MAX_TIMESTAMP_LOOKAHEAD=50
Tags (2)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi a212830,
for me the best approach to a timestamp problem is to download an example of your log in a file and try to ingest it using the Splunk web gui.
In this way you can immediately check your configurations and verify problems.

In your specific situation, the problem could be in MAX_TIMESTAMP_LOOKAHEAD=18 and TIME_PREFIX=\d+\s\w+\s

Bye.
Giuseppe

DalJeanis
Legend

Upvote for likely correct TIME_PREFIX to fix the OP's issue.

0 Karma

sloshburch
Splunk Employee
Splunk Employee

Agreed. I was gonna say TIME_PREFIX as well.

0 Karma
Get Updates on the Splunk Community!

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!

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

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...