Getting Data In

How to edit my props.conf to extract a timestamp in the middle of a log?

prakash007
Builder

I have a log file where i need to do a Timestamp extraction which is in the middle of the log....

somehow it's capturing 2017 8:09:16 PM Is R(from the next line)

NewStatServer ----------------------------------
Started Time: 3/16/2017 8:09:16 PM
Is Running: True

TIME_FORMAT = %m/%d/%Y  %H:%M:%S %p
TIME_PREFIX = Started\sTime\:\s
MAX_TIMESTAMP_LOOKAHEAD = 20
0 Karma
1 Solution

woodcock
Esteemed Legend

Try this (every line has changed):

TIME_FORMAT = %m/%d/%Y  %I:%M:%S %p
TIME_PREFIX = [\r\n]Started Time:\s*
MAX_TIMESTAMP_LOOKAHEAD = 22

Deploy to your Indexers and restart your Splunk instances there. Test by checking ONLY for events indexed AFTER the restarts.

View solution in original post

0 Karma

woodcock
Esteemed Legend

Try this (every line has changed):

TIME_FORMAT = %m/%d/%Y  %I:%M:%S %p
TIME_PREFIX = [\r\n]Started Time:\s*
MAX_TIMESTAMP_LOOKAHEAD = 22

Deploy to your Indexers and restart your Splunk instances there. Test by checking ONLY for events indexed AFTER the restarts.

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

What Is Splunk? Here’s What You Can Do with Splunk

Hey Splunk Community, we know you know Splunk. You likely leverage its unparalleled ability to ingest, index, ...

Level Up Your .conf25: Splunk Arcade Comes to Boston

With .conf25 right around the corner in Boston, there’s a lot to look forward to — inspiring keynotes, ...

Manual Instrumentation with Splunk Observability Cloud: How to Instrument Frontend ...

Although it might seem daunting, as we’ve seen in this series, manual instrumentation can be straightforward ...