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!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...