Splunk Enterprise Security

Best practice to get local time of event

Haleb
Explorer

Please advise on the optimal solution for this business task. I have a set of events with the following fields:

 

 

city: Almaty
country: KZ
latitude: 43.2433
longitude: 76.8646
region: Almaty

 

 

What would be the best approach to obtain the field indicating the local time of these events using the provided information?

Labels (2)
Tags (3)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

MaxMind offer a database you download to map lat/long to time zone, among other fields.  The database can replace that used by Splunk for the iplocation command or you can use the CSV version of the DB as a separate lookup table.  A subscription may be required.  See https://www.maxmind.com/en/geoip-databases

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...