Getting Data In

timestamp not being handled properly

a212830
Champion

Hi,

I'm having issues getting Splunk to properly recognize the date on some logfiles. The input is pretty simple:

10-Dec-12 12:28:36 ELEMENT=ABCDEF METRIC=Average_CPU_Utilization METRIC_VALUE=37.00000000 DURATION=303
10-Dec-12 12:33:39 ELEMENT=ABCDEF METRIC=Average_CPU_Utilization METRIC_VALUE=52.00000000 DURATION=300
10-Dec-12 12:38:39 ELEMENT=ABCDEF METRIC=Average_CPU_Utilization METRIC_VALUE=55.00000000 DURATION=299
10-Dec-12 12:43:38 ELEMENT=ABCDEF METRIC=Average_CPU_Utilization METRIC_VALUE=38.00000000 DURATION=302

My props file has the following:

[snmpinfo]
MAX_TIMESTAMP_LOOKAHEAD = 35
NO_BINARY_CHECK = 1
SHOULD_LINEMERGE = false
TIME_FORMAT = %d-%b-%y %H:%M:%S
TIME_PREFIX = ^

The time is getting picked up properly, but the date is coming in as 12/12/10. What am I doing wrong? I looked at the strptime, and it looks correct to me. This data is coming in from a heavy-forwarder to an indexer.

Tags (1)
0 Karma

sowings
Splunk Employee
Splunk Employee

If the data is being picked up from a heavy forwarder (read: event aware) it's doing the parsing of time stamps; you'll want to ship the same bit of configuration over to the heavy as well.

0 Karma

a212830
Champion

That's where I have the props.conf - on the forwarder. Should I put it on the indexer as well? If yes, why?

0 Karma
Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...