Getting Data In

Why are similar events showing different datetimes?

douglasmsouza
Explorer

I'm facing something strange about _time and timezone.

We have 2 hosts indexing the same event type (Unix:Uptime).

On the search head, I have the following situation:

1 - The first host shows the correct timestamp
2 - The second host shows the timestamp 1 hour ago

The events have the same timezone and the same "date_hour" field.

What I'm doing wrong?

alt text

0 Karma

woodcock
Esteemed Legend

Ignore all the date_* fields unless you desire to ignore your personal Time zone setting and like the time normalized to UTC/GMT (which is what those fields are). Check your Time zone setting and also the _indextime value. I suspect that you are seeing the result of falling back for Daylight Savings.

0 Karma

codebuilder
Influencer

Daylight savings kicked in over the weekend. Have you validated that the OS properly updated the time on the box where the forwarder is off?

----
An upvote would be appreciated and Accept Solution if it helps!

douglasmsouza
Explorer

Hi,

Yes, I have already checked the time in the universal forwarders, heavy forwarders, indexers and search heads.

Here in Brazil the daylight savings should have started the last weekend, but we don´t have it anymore.

Note that the raw events is being indexed with the correct timestamp, but in some cases the search head shows the wrong date.

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!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...