Getting Data In

Backloading events with no year in timestamp

msorenson
Explorer

I have some month old syslog data that I need to load into an indexer, but the timestamp doesn't have the year. Is there a way to force the indexer to leverage the defined month, day and time against the current year? Can this be done through an index time props TIME_FORMAT?

Takajian
Builder

You can refer to following site.

http://docs.splunk.com/Documentation/Splunk/latest/Data/HowSplunkextractstimestamps

Splunk uses the following precedence to assign timestamps to events:

  1. Look for a time or date in the event itself using an explicit TIME_FORMAT if provided.

Use positional timestamp extraction for events that have more than one timestamp value in the raw data.

  1. If no TIME_FORMAT is provided, or no match is found, attempt to automatically identify a time or date in the event itself.

Use positional timestamp extraction for events that have more than one timestamp value in the raw data.

  1. If an event doesn't have a time or date, use the timestamp from the most recent previous event of the same source.

  2. If no events in a source have a date, look in the source (or file) name (Must have time in the event).

  3. For file sources, if no time or date can be identified in the file name, use the modification time on the file.

  4. If no other timestamp is found, set the timestamp to the current system time (at the event's index time).

  5. For file sources, if no time or date can be identified in the file name, use the modification time on the file.

  6. If no other timestamp is found, set the timestamp to the current system time (at the event's index time).

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Kick the Tires Before You Commit: A Hands-On Tour of the Splunk Observability Cloud ...

Evaluating an enterprise observability platform usually goes like this: fill out a form, get a free trial with ...

Deep insights, no barriers: Splunk Observability Cloud Free Edition

As software delivery cycles continue to accelerate, observability shouldn’t be a luxury — it should be a ...

Monitoring AI Agents with Splunk Observability Cloud

Let’s say I’m running a travel planning AI app in production. A user asks for three concise hotel options in ...