Getting Data In

Help to get only number from Number of Files Found

Suganya_S
New Member

Hi Team,
My Query : index=*** kubernetes.container_name=*** cluster_id=*** "Number of Files Found"

Result will be like : Number of Files Found  2(or any number)


I need to get that number value alone, when it is > 0 the count have to be displayed as any chart. How can I edit my query to get like that. Do we have any option for that? Please suggest.
Thanks! 

Labels (1)
0 Karma

Suganya_S
New Member

Hi @aasabatini the count of the log will always be > 0. Here I basically would like to split the log statement so as to get the number alone. 

0 Karma

aasabatini
Motivator

Hi @Suganya_S 

if you see my example search there is a where condition to force to select the count > 0

 where count > 0
“The answer is out there, Neo, and it’s looking for you, and it will find you if you want it to.”
0 Karma

aasabatini
Motivator

Hi @Suganya_S 

 

try to use stats comand

https://docs.splunk.com/Documentation/Splunk/8.1.3/SearchReference/Stats

index=*** kubernetes.container_name=*** cluster_id=*** "Number of Files Found" | stats count | where count > 0

 

“The answer is out there, Neo, and it’s looking for you, and it will find you if you want it to.”
0 Karma
Get Updates on the Splunk Community!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...