I am trying to search from source A that contains IP and trying to lookup IP location from a database that contains the subnet information with begin and end decimal. I'm trying to use Splunk DB Connect v2 to extract the database information to spreadsheet and that works but not sure how to use the ip information from source A to lookup the location information in database that only contains begin and end decimal information.
Example:
source="A" ip="192.168.0.23"
database contains = IP address begin = "3232235520" , IP address end = "3232235775" , location="building_a"
Example Result: ( table ip, location )
ip location
192.168.0.23 building_a
... View more