Splunk Search

where command for innotnull

AditiGhule
New Member

Hi,
I'm new to splunk and
I'm trying to exclude null values for one of the columns in my datasheet.
That column as two different values and few rows are blank.
Tried where command but not getting the result.
values of the columns "Stage 1" are "Stage1" & "Stage2" & remaining blank rows

| where isnotnull("Stage 1")...... ---- didn't work
| where "Stage 1" = "Stage1" OR "Stage2" ..... -------didn't work

Please help me with this.

Tags (1)
0 Karma

vnravikumar
Champion

Hi

Give a try

yourquery...|search "Stage 1"=*
0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...