Splunk Search

Could not use strptime to parse timestamp

stwong
Communicator

Hi all,

I'm adding detail files from FreeRadius, which looks like following:

Wed May 2 10:28:04 2012
NAS-IP-Address = 192.168.193.67
User-Name = "a12345677"
NAS-Port = 0
NAS-Port-Type = Wireless-802.11
[snipped]

I specified following in props.conf:

TIME_FORMAT=%a %b %d %H:%M:%S %Y
TIME_PREFIX=^

The Data Preview panel complains about "Could not parse strptime to parse timestamp", although it is still okay to identify individual records. I wonder if I make any mistake in the format string . Would anyone please help?

Thanks a lot.

Tags (1)

goelli
Communicator

Is there any news on this topic?
I have the same problem...

0 Karma

stwong
Communicator

I left this question unchecked for long tims, as the time can be parsed correctly...

0 Karma

stwong
Communicator

Same result after changing %d to %e.
Anyway, thanks for your help.

/ST

0 Karma

kristian_kolb
Ultra Champion

see update above. /k

0 Karma

kristian_kolb
Ultra Champion

You should change the %d (01-31) for a %e (1-31) in TIME_FORMAT.


UPDATE:
What are the values for timestartpos and timeendpos? Do they correspond to where your timestamp begins and ends? Those fields are automatically extracted, but to see them you may have to click the "View all XX fields" in the field picker on the left.

Perhaps you need to remove/change the TIME_PREFIX and specify a MAX_TIMESTAMP_LOOKAHEAD.

Please post a complete event, and what time splunk interprets, and the timestartpos and timeendpos.

Hope this helps,

Kristian

sdaniels
Splunk Employee
Splunk Employee

I didnt see that option...good to know.

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!

Take Action Automatically on Splunk Alerts with Red Hat Ansible Automation Platform

 Are you ready to revolutionize your IT operations? As digital transformation accelerates, the demand for ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...

Beyond Detection: How Splunk and Cisco Integrated Security Platforms Transform ...

Financial services organizations face an impossible equation: maintain 99.9% uptime for mission-critical ...