Splunk Search
Highlighted

Timezone query to modify _time field if the user's timezone is not UTC.

Explorer

I have a dropdown in my dashboard where I provide static label and value for 4 timezones as of now(UTC,ET,PST,CT) (Which maybe increased in future). Now, Upon choosing a timezone value from the dropdown, I will have to adjust _time in a search query(of a panel/input in my dashboard) like this--> "mysearch" | eval _time = _time (+ or - ) (x6060) | "rest of mysearch" (If I'm right, this approach is correct if the current user's timezone is set to UTC). But, the currently logged in user's timezone maybe any among UTC,ET,PST,CT. So, I will be overriding the timezone configured in the settings. How can I modify my search query for _time field dynamically taking into account the user's current timezone and considering daylight savings time for the above mentioned timezones as well ?

0 Karma
Highlighted

Re: Timezone query to modify _time field if the user's timezone is not UTC.

Super Champion

if you do some evaluating, you should be able to put it all into UTC first.

|convert ctime(_time) as date timeformat="%Y-%m-%d"|eval _time=strptime(date,"%Y-%m-%d")
0 Karma
Highlighted

Re: Timezone query to modify _time field if the user's timezone is not UTC.

Explorer

I understand the approach you're suggesting @cmerriman, but I'm afraid this query does not exactly satisfy my requirement. Also, Thanks for the answer.

0 Karma
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.