Splunk Search

Splunk counting issues/skills

asimagu
Builder

Hey guys

I am a bit puzzled by the counting skills of Splunk.

I have a dashboard with 3 panels that will show a count by clientip in some access_logs, so when I fire the same search on the 3 panels with a time window of one month, I get different values in each ones of the counts of each panel. They only differ in small numbers, but I still find it very odd that Splunk is not getting to the same results every time....

I'm using the geoip command on those searches...I am guessing that might something to do?

Tags (2)
0 Karma
1 Solution

asimagu
Builder

I finally spotted the problem. It was the version of Firefox that I was using.... everything worked alright on Chrome

View solution in original post

0 Karma

asimagu
Builder

I finally spotted the problem. It was the version of Firefox that I was using.... everything worked alright on Chrome

0 Karma

asimagu
Builder

parent search:
eventtype="pyme_page" status=200 | geoip clientip | search clientip_country_name="$country$" | fields clientip _time date_hour date_wday

postprocess 1:
stats count(clientip) | rangemap field=count(clientip) low=0-29 elevated=30-99 high=100-500 severe=501-10000 default=low

and that is replicated 3 exact times in my dashboard, in each of the panels. I was lost and that's why I came here to ask, I'm really suspecting it has something to do with the geoip command...

0 Karma

Ayn
Legend

OK. Hard to say without having more details. If these searches are truly identical and operate on a fixed timeframe for which no events are added, I'm at a loss. I'm pretty sure there's something going on with either of those assumptions though. You might want to have a look at the job inspector for each of the searches to see if/why they behave differently.

0 Karma

asimagu
Builder

The idea of that dashboard was to make comparisons between different timeframes and different values of certain fields. I spotted some discrepancies between the same searches in two dashboards so I decided to run the same exact search in those 3 panels at the same time.... and surprise! I got 3 different results for the count of events: 1794, 1797, 1789 ..... so strange!

0 Karma

Ayn
Legend

OK. What's the difference between the 3 searches, since you're using 3 panels rather than just 1 I assume something's different at least?

0 Karma

asimagu
Builder

I'm afraid not, it does not include current time. I am running those searches through the month of June

0 Karma

Ayn
Legend

Are you running these searches on an interval that includes the current time? Because in that case if you run 3 searches and you have data constantly flowing in, obviously the second search will get some new data that the first search didn't get...and same thing with the third search.

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!

Persistent Queue at TcpOut — One of Splunk's Most Practical Features

Splunk introduced persistent queueing at the tcpout layer as one of the most practical resilience features in ...

Skip the Awkward Silence: Have a .conf-ersation at .conf26

Picture this. You arrive at .conf26 already having your socializing and networking plans mapped out. No ...

Rethinking Zero Trust: From Product Purchases to Logical Control Evidence

Implementing Zero Trust (ZT) across complex environments often falters at the very beginning due to a ...