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
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 Data to Insight: Announcing the Winners of the Splunk Dashboard Contest

Hi Splunkers, First off, thank you to everyone who participated in our very first From Data to Insight: The ...

Splunk Developers: Construct Your Future at the .conf26 Builder Bar

Calling all Splunk architects, platform admins, and app developers: the site is open, and the blueprints are ...

Quick connection discovery mode for forwarders

When a Splunk forwarder loses connectivity to its indexers, it does not always reconnect immediately. In many ...