Getting Data In

Time Prefix Question

edwardrose
Contributor

Hello All

I have a time prefix question

Here is my timestamp

May 20 10:59:30 svr-orw-nac-01 2020-05-20 17:59:30,646
May 20 11:01:01 svr-ies-nac-02 2020-05-20 18:01:01,389

I am setting props.conf to be the following:

[source::/var/log2/gns/nac/log_*]
MAX_TIMESTAMP_LOOKAHEAD = 31
TIME_PREFIX = ^\w+\s\d+\s\d+:\d+:\d+\ssvr-.*-nac-\d[01|02]\s
TIME_FORMAT = %Y-%m-%d %H:%M:%S,%3N

Does this look right?

Thanks
ed

0 Karma

PavelP
Motivator

Hello @edwardrose,

small corrections:

TIME_PREFIX = ^\w+\s\d+\s\d+:\d+:\d+\ssvr\-\w+\-nac-(01|02)\s

it is better to use \w+ instead of .* - the first requires 58 steps instead of 126 steps, compare:

https://regex101.com/r/cOQ2a2/1 - 126 steps

https://regex101.com/r/cOQ2a2/2 - 58 steps

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...