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!

Index This | Why did the turkey cross the road?

November 2025 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  &#x1f680; Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Feel the Splunk Love: Real Stories from Real Customers

Hello Splunk Community,    What’s the best part of hearing how our customers use Splunk? Easy: the positive ...