Getting Data In

TIME_PREFIX regex help

wouterr
Explorer

Hi,

I seem to be incapable of figuring out what regex to provide in the TIME_PREFIX for my source type in order to recognize the second time stamp instead of the first.

Please see a sample event below

"Jun 04 2013 12:00:00:001AM","5333079266","310410257633304","8","Jun 03 2013 03:55:43:000PM"

Thanks

Tags (2)
0 Karma
1 Solution

Hajime
Path Finder

Hello wouterr,

I think as you said bmacias84, and may be set as follows.

TIME_PREFIX=","

OR

TIME_PREFIX=,"

View solution in original post

0 Karma

Hajime
Path Finder

Hello wouterr,

I think as you said bmacias84, and may be set as follows.

TIME_PREFIX=","

OR

TIME_PREFIX=,"

0 Karma

bmacias84
Champion

I see you have two timestamps so you want the second timestamp used for _time? if so try


TIME_PREFIX=","
TIME_FORMAT=%b %d %Y %I:%M:%S:%3N:%r

0 Karma
Get Updates on the Splunk Community!

Reduce and Transform Your Firewall Data with Splunk Data Management

Managing high-volume firewall data has always been a challenge. Noisy events and verbose traffic logs often ...

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...