https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403344#M71665 <P>Do you have that information (City that user loggen in from) available in your data?<BR /> It would be a lot easier for us if you could post some example data. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 18 May 2018 07:33:19 GMT xpac 2018-05-18T07:33:19Z https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403343#M71664 <P>I need to create a report of all remote logins of users. All the times are in EST in Splunk.<BR /> We need to convert it to timezone of the specific City that the user logged in from. It should even consider daylight savings time in the report.</P> Thu, 17 May 2018 20:40:48 GMT https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403343#M71664 jarapally 2018-05-17T20:40:48Z https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403344#M71665 <P>Do you have that information (City that user loggen in from) available in your data?<BR /> It would be a lot easier for us if you could post some example data. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 18 May 2018 07:33:19 GMT https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403344#M71665 xpac 2018-05-18T07:33:19Z https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403345#M71666 <P>Can I point you to this answer:</P> <P><A href="https://answers.splunk.com/answers/241917/timezone-conversion-function.html">https://answers.splunk.com/answers/241917/timezone-conversion-function.html</A></P> Fri, 18 May 2018 10:34:26 GMT https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403345#M71666 Azeemering 2018-05-18T10:34:26Z https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403346#M71667 <P>Yes we do have the city users log in from. </P> Fri, 18 May 2018 13:20:36 GMT https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403346#M71667 jarapally 2018-05-18T13:20:36Z https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403347#M71668 <P>This link only shows UTC to EST but we have multiple cities across the globe from which users log in and need to consider day light savings time as well</P> Fri, 18 May 2018 13:21:50 GMT https://community.splunk.com/t5/Getting-Data-In/Convert-time-to-the-specific-City-Timezone/m-p/403347#M71668 jarapally 2018-05-18T13:21:50Z