Reporting

Eliminating empty records from display

Jananee_iNautix
Explorer

Hi,

I have a report displayed in table format .The search query currently includes and displays the records that have all the fields conatining null values in it.There is a requirement to eliminate the records that has the fields containing no values in it. For Example

Filename user server............service
1)
2) abbc ftyfe reg.............ferwe

In the above report record 1) should be eliminated from display .Is there any way to do it.Please advise.

Tags (1)
0 Karma

somesoni2
Revered Legend

Can you post your current search query?

0 Karma

linu1988
Champion

Try

source=test Filename!=""|table *

or

source=test NOT isnull(Filename)|table *

Thanks

0 Karma
Get Updates on the Splunk Community!

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

New Learning Videos on Topics Most Requested by You! Plus This Month’s New Splunk ...

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

How I Instrumented a Rust Application Without Knowing Rust

As a technical writer, I often have to edit or create code snippets for Splunk's distributions of ...