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!

Splunk MCP & Agentic AI: Machine Data Without Limits

  Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization ...

Finding Based Detections General Availability

Overview  We’ve come a long way, folks, but here in Enterprise Security 8.4 I’m happy to announce Finding ...

Get Your Hands Dirty (and Your Shoes Comfy): The Splunk Experience

Hands-On Learning and Technical Seminars  Sometimes, you just need to see the code. For those looking for a ...