Splunk Search

stats min(count) not 0 if value never occurs

viggor
Path Finder

If I have the following query

foo
| timechart span=60s  count 
| stats min(count) as minCntFoo

but foo never occurs, is there a way of setting minCntFoo=0 instead of now, where I get "No results found."?

0 Karma

cmerriman
Super Champion

try this:

foo
 | timechart span=60s  count 
 | stats min(count) as minCntFoo
| appendpipe [ stats count | eval minCntFoo=0 | where count==0 |table minCntFoo]

the appendpipe stats command will count the number of events that come back and only bring back results if there are 0 events from the base query.

Get Updates on the Splunk Community!

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...