All Apps and Add-ons

What counts as a "distinct location" in the Google Maps module?

NK_1
Path Finder
In the Google Maps display, we see "xxx results with location information ( yyy distinct locations) over all time".

What constitutes a "distinct location" ? e.g.

... ip starttime=03/23/2011:08:00:00 endtime=03/24/2011:08:00:00  | stats count(ip)
--> 98346

And the unique IPs for that same result set:

... ip starttime=03/23/2011:08:00:00 endtime=03/24/2011:08:00:00  | dedup ip | stats count(ip)
--> 46411

I've also verified that "... | dedup ip | stats count(ip)" returns the same value as "... |  stats distinct_count(ip)"

Using the Google Maps module, I see the former query has 14085 distinct locations:

... ip starttime=03/23/2011:08:00:00 endtime=03/24/2011:08:00:00  | geoip ip
--> 95393 results with location information ( 14085 distinct locations) over all time

One would imagine removing duplicate IPs should not change the number of distinct locations, but it does (increases to 14165):

... ip starttime=03/23/2011:08:00:00 endtime=03/24/2011:08:00:00  | dedup ip | geoip ip
--> 46243 results with location information ( 14165 distinct locations) over all time
1 Solution

ziegfried
Influencer

A distinct locations is a unique combination of the latitude and longitude values (ie. the values of the fields _lat and _lng). It's calculated by appending | stats count as _geo_count by _lat,_lng as a postprocess to the search.

The only reason I can imagine that would explain those results is that the geoip commands somehow failed (crashed) on some of those IP values. The next version should fix this though.

Also in the upcomming version of the Google Maps there will be a single field _geo which will contain both latitude and longitude values separated by comma.

View solution in original post

0 Karma

ziegfried
Influencer

A distinct locations is a unique combination of the latitude and longitude values (ie. the values of the fields _lat and _lng). It's calculated by appending | stats count as _geo_count by _lat,_lng as a postprocess to the search.

The only reason I can imagine that would explain those results is that the geoip commands somehow failed (crashed) on some of those IP values. The next version should fix this though.

Also in the upcomming version of the Google Maps there will be a single field _geo which will contain both latitude and longitude values separated by comma.

0 Karma
Get Updates on the Splunk Community!

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...