Splunk Search

Show IP address while using Geostats and iplocation

aking76
Path Finder

I created a map showing connections outside the US but when I hover over the markers it only shows the lon and lat. I would like to have it show the IP instead.

Is it also possible to have it display the statistics? That way I have a table showing these connections and then the map as well.

Currently, I have a map and a stats table that I put on the dashboard but I would like to have these combined if possible.

Here's my query to show the connections outside the US on a map.

index=syslog earliest=-6h NOT
| iplocation dest_ip|search NOT Country="United States"
|geostats count

Here's the same query that I have displayed as a statistics table-
index=syslog* earliest=-6h
| iplocation dest_ip|search NOT Country="United States"
| Table dest_ip count City Country|rename dest_ip as "Destination IP" count as "Connections"
|Sort by Country

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

From Raw Data to Executive-Ready Stories, Faster

Build Data Stories for Every Audience  A dashboard is rarely just a dashboard. It might be the view an ...

Guided Onboarding with Auto-schema Is Now Generally Available

  We are excited to announce the General Availability of Guided Onboarding with Auto-Schematization ...

ATTENTION: We’re Moving! (AGAIN!)

The Splunk Community Slack is undergoing a system migration to keep our workspace secure and ...