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!

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...