Splunk Search

How do I run a lookup on a list of cities/countries with latitude and longitude and plot them on a map visualization?

xbbj3nj
Path Finder

Hi,

I have a list of cities and countries along with latitude and longitude.

Name   Latitude Longitude
India    Blah       Blah
US        Blah       Blah

Now how do I lookup on them and plot on a map visualization in Splunk? (geostats, iplocation, etc)

Thanks in advance

0 Karma

MuS
SplunkTrust
SplunkTrust

Hi xbbj3nj,

let's say your lookup file is called cities.csv and the lookup is called cities then you can run this search :

 your base search here to get back city name | lookup cities | geostats latfield=Latitude longfield=Longitude count

and use the map visualisation to show it on a map.

See the docs for more details:
http://docs.splunk.com/Documentation/Splunk/6.3.3/SearchReference/Lookup
http://docs.splunk.com/Documentation/Splunk/6.3.3/SearchReference/Geostats

Hope this helps ...

cheers, MuS

0 Karma

frobinson_splun
Splunk Employee
Splunk Employee

Depending on the way you want results to show up on a map, a Choropleth map visualization might also be useful. See this documentation:
http://docs.splunk.com/Documentation/Splunk/6.3.3/Viz/Choroplethmaps

0 Karma
Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...