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
Get Updates on the Splunk Community!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...