Splunk Enterprise

Exclude Fields with null value from table

jt_yshi
Engager

Hello Splunk Community,

 

I am looking for some help.

 

I would like to make an audit of all fields where there is not NULL for a given event. Which means I want a table with all fields where the vaule is not NULL. The thing is I do not want to have to specify the fields as there are too many and I am creating an audit of all fields that have values. It would take too much time to specify the field names in the search and or table. Hence, I am looking for a solution that lists all fields != NULL

I tried: 

|fillnull value="NULL"
|search NOT "NULL"
|table*
 
and many other searches with metadata, metasearch and audit commands. I cannot seem to find the right syntax to exclude fields with a given field value eg NULL or simply empty ones.

 
Thank you in advance for you help!!
 
best,
julia 
Labels (1)
0 Karma
Get Updates on the Splunk Community!

Learn Splunk Insider Insights, Do More With Gen AI, & Find 20+ New Use Cases You Can ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Buttercup Games: Further Dashboarding Techniques (Part 7)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Stay Connected: Your Guide to April Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...