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!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...