Splunk Search

How can I handle a time stamp with flexible spaces?

ddrillic
Ultra Champion

We have a syslog data that was written to disk via the FULLDATE macro. For today, it looks like — 2019 Apr 3 19:30:01 with double space. I assume that it would be 2019 Apr 13 19:30:01 in ten days with only one space.

I wonder which format to use in props.conf -

TIME_FORMAT=%Y %b %d %H:%M:%S works fine for 2019 Apr 3 19:30:01 but not for 2019 Apr 13 19:30:01, which is counter intuitive to me.

On Unix, I see -

date "+%Y %b %d %H:%M:%S" as 2019 Apr 03 15:45:41. Apparently space and zero are interchangeable.

Any ideas?

Tags (2)
0 Karma

ddrillic
Ultra Champion

This warning threw me off ; -)alt text

0 Karma

ddrillic
Ultra Champion

It seems that it was my bad - it works just fine.

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...