I need to create a report of all remote logins of users. All the times are in EST in Splunk.
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.
Can I point you to this answer:
https://answers.splunk.com/answers/241917/timezone-conversion-function.html
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
Do you have that information (City that user loggen in from) available in your data?
It would be a lot easier for us if you could post some example data. 🙂
Yes we do have the city users log in from.