Getting Data In

Timestamp containing newline

las
Contributor

Hi.

 

I have just been presented with a very curious timestamp format.

 

 

18-08-2020 
15:41:00,07 
No running service instances found
0 service instances are online, which is different from the expected count of 1.
18-08-2020 
15:46:00,13 
No running service instances found
0 service instances are online, which is different from the expected count of 1.

 

 

 

My first instinct is to create a timeformat = %d-%m%Y\n%H:%M:%S,%2N, but is it at all possible to mix regex with strptime() formats?

Has anybody encountered something like it, and what solution did you come up with.

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

las
Contributor

Sorry, that is two events. Splunk by the timestamp containing the newline.

SHOULD_LINEMERGE = true

Just after I posted this I got thinking, and startet playing with LINE_BREAKER=([\r\n]+)\d{2}-\d{2}, that seems to be able to do the trick

View solution in original post

0 Karma

thambisetty
SplunkTrust
SplunkTrust

is that single event?

what is your SHOULD_LINEMERGE for this sourcetype?

————————————
If this helps, give a like below.
0 Karma

las
Contributor

Sorry, that is two events. Splunk by the timestamp containing the newline.

SHOULD_LINEMERGE = true

Just after I posted this I got thinking, and startet playing with LINE_BREAKER=([\r\n]+)\d{2}-\d{2}, that seems to be able to do the trick

0 Karma
Get Updates on the Splunk Community!

Get Schooled with Splunk Education: Explore Our Latest Courses

At Splunk Education, we’re dedicated to providing incredible learning experiences that cater to every skill ...

Splunk AI Assistant for SPL | Key Use Cases to Unlock the Power of SPL

Splunk AI Assistant for SPL | Key Use Cases to Unlock the Power of SPL  The Splunk AI Assistant for SPL ...

Buttercup Games: Further Dashboarding Techniques (Part 5)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...