Getting Data In

What is causing Constant time diff of 12 hrs (_indextime - _time)?

pavanbmishra
Path Finder

Hi,

 

There is constant time diff (_indextime - _time) from few windows server as below, not sure what causing this and how to fix it

pavanbmishra_0-1651137952203.png

 

Labels (1)
Tags (1)
0 Karma

pavanbmishra
Path Finder

Thanks Giuseppe, seems to be AM/PM parsing issue. How this could be addressed?

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @pavanbmishra,

you should see your logs and the props.conf related to your sourcetype and eventually add to it the timezone definition.

Ciao.

Giuseppe

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @pavanbmishra,

a fixed difference like this can have one of the following three causes:

  • there's a timezone difference to consider;
  • a timestamp parsing error: the timestamp parsing doesn't consider AM/PM;
  • servers internal clock aren't aligned.

In my experience the fist option is the more possible.

In this case you have to analyze your logs and the parser and change the timezone setting.

Ciao.

Giuseppe

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!

ATTENTION: We’re Moving! (AGAIN!)

The Splunk Community Slack is undergoing a system migration to keep our workspace secure and ...

Deep Dive: Optimizing Telemetry Pipelines in Splunk Observability Cloud

In this session, we will peel back the layers of Splunk Observability Cloud’s cost-optimization features. ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...