Getting Data In

How to ignore timezone offset in timestamp?

rrich
Explorer

Hi there,

I have an application that is incorrectly reporting the current timezone is GMT -0500 with timestamps of the following form:

[29/Oct/2010:15:59:50 -0500]

(Currently we're on EDT which is -0400)

Is there a way i can accept the timestamp but ignore the offset? Currently all events are marked an hour in the future?

Thanks!

Tags (2)
0 Karma
1 Solution

southeringtonp
Motivator

You can set an explicit time format in props.conf and leave the timezone offset out.

Take a look at:
     http://www.splunk.com/base/Documentation/latest/Admin/Configuretimestamprecognition

and look specifically at the TIME_FORMAT option.

View solution in original post

0 Karma

southeringtonp
Motivator

You can set an explicit time format in props.conf and leave the timezone offset out.

Take a look at:
     http://www.splunk.com/base/Documentation/latest/Admin/Configuretimestamprecognition

and look specifically at the TIME_FORMAT option.

0 Karma

kmanson
Path Finder
0 Karma

rrich
Explorer

Awesome. Thank you!

0 Karma
Get Updates on the Splunk Community!

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...

From GPU to Application: Monitoring Cisco AI Infrastructure with Splunk Observability ...

AI workloads are different. They demand specialized infrastructure—powerful GPUs, enterprise-grade networking, ...

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...