Splunk Search

how to enrich the iplocation database with private IP addresses?

wsw70
Communicator

Hello

I successfully use iplocation to map PUBLIC IP addresses on the built-in splunk> map.

I also would like to map PRIVATE ones (RFC 1918) via an IP <-> location table I would manually maintain. How can I do this?

0 Karma

tgow
Splunk Employee
Splunk Employee

I would try and use the geostats command to use a lookup file that has your private addresses. The lookup file would need to have the longitude and latitude information in it as well then you just tell the geostats command which field in the lookup file is the longitude/latitude fields. Here is an example search:

sourcetype=vendor_* | lookup price_lookup Code OUTPUTNEW product_name | table product_name VendorID | lookup vendors_lookup VendorID | geostats latfield=VendorLatitude longfield=VendorLongitude count by product_name

Here is a link to more information:

http://docs.splunk.com/Documentation/Splunk/6.1.3/SearchReference/Geostats

0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...