Getting Data In

Searching indexes with your timezone set differently to the data's timezone

mtmoore
Explorer

Our data's date field uses UTC for all data across the globe for this one set of data. This is fine.

When a user runs a search using earliest and latest, unless I am mistaken, the date/time field it uses will be the timestamp placed on the data by Splunk and not the date field that is in the logs.

This is all well and good if the 2 date/times match up - even then though the user can change their timezone and this goes out of whack.

How can I force the search to look at the last 7 days using the UTC date/time stamp within the log itself and not Splunk's date/time stamp?

Thanks!

Tags (1)
0 Karma

blebit
Path Finder

or you can edit from your server

props.conf

[host:: the_host]
TZ = Location_TimeZone

0 Karma

mtmoore
Explorer

How will this force a search to use the date time zone of the raw log as opposed to the Splunk date/time based on your personal timezone settings?

0 Karma

blebit
Path Finder

props.conf @ remote location

TZ=Location_TimeZone

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!

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...

Beyond Detection: How Splunk and Cisco Integrated Security Platforms Transform ...

Financial services organizations face an impossible equation: maintain 99.9% uptime for mission-critical ...

Customer success is front and center at .conf25

Hi Splunkers, If you are not able to be at .conf25 in person, you can still learn about all the latest news ...