Splunk Search

Why is my search returning less results when it should return the same?

carsonl
Explorer

Hi all,

Some background...
We have a large amount of data coming in, and the filename is used to derive some of the fields.

One of the fields is 'cclient', as we can see from the below search, it is extracting the field correctly:

index=bluecoat source=*Fox* earliest=-2w | stats count by cclient
    cclient count
    Fox_8   48412

However when searching, something strange happens... even though the data is there, it is returning substantially less than the previous query

index=bluecoat cclient=Fo* earliest=-2w | stats count by cclient
    cclient count
    Fox_8   1483

Even less when you go more specific...

index=bluecoat cclient=Fox* earliest=-2w | stats count by cclient
    cclient count
    Fox_8   1309

and even less again when you get even more specific...

index=bluecoat cclient=Fox_8 earliest=-2w | stats count by cclient
    cclient count
    Fox_8   27

Utilising quotes doesn't change anything. I have also cleared all eventdata from this index to ensure the change of data didn't do anything weird.

It is worth noting that when the string was "Fox 8", there wasn't this problem. I had to change the data to replace the space with an underscore, as tags cannot contain spaces... even when wrapped in quotes.

Has anyone seen this before? Is there a resolution/workaround?

I haven't updated to 4.3 yet...

Regards,

Carson.

Tags (2)
0 Karma
1 Solution

carsonl
Explorer

It appears that upgrading to 4.3 fixed the issue. Makes me believe this was a Splunk bug.

View solution in original post

0 Karma

carsonl
Explorer

It appears that upgrading to 4.3 fixed the issue. Makes me believe this was a Splunk bug.

0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...