Splunk Search

Geostats Truncating Data?

vliu2
Explorer

It would appear that using ...| geostats isn't working as it used to anymore. I originally had a search like the following in order to visualize where users were logging in from:

(index="user_logins" session="*") OR (index="ssh" password="Accepted") | iplocation IP | table user lon lat | geostats globallimit=0 count by user

I originally ran into the problem where Splunk would truncate the data shown and found that globallimit=0 appeared to be a fix. Well, it's been about a month and the problem is back (even with globallimit=0). To be exact, Splunk decides to truncate the amount of data it shows after the job finishes. It looks perfectly fine while performing the search, but then it decides to only display the geo-ip location of two users rather than a hundred or so.

Has anyone ran into this problem or have any suggestions to fix this problem?

0 Karma
1 Solution

vliu2
Explorer

It would appear that deleting ...| table user lon lat solved my problem. It's strange because it worked perfectly fine with it before. Strange.

View solution in original post

0 Karma

vliu2
Explorer

It would appear that deleting ...| table user lon lat solved my problem. It's strange because it worked perfectly fine with it before. Strange.

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...