Splunk Search

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

waltz
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 - ) (x*60*60) | "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

cmerriman
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

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

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...