Reporting

Eliminating empty records from display

Jananee_iNautix
Path Finder

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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...