Splunk Search

Top syntax to display null fields when using 'by'?

Tisiphone_1
Explorer

When I use 'top' to create a top n list of fields, and I add two fields, using by, so:

top field1 by field2

if either field is not present in a result, it does not display in the list. I want to display events in my results even the secondary field is null. Is there any way to do this?

For example:

top infected person by infection

Even if I don't know what infection it is, I still want them to show up on the list of infected people, and I still want to see the infection if it is available.

1 Solution

Stephen_Sorkin
Splunk Employee
Splunk Employee

The best way to do this is to use the fillnull command to make the desired fields dense. In this case, you could try:

... | fillnull value=NULL person infection | top person by infection

View solution in original post

Tisiphone_1
Explorer

Thanks a ton, Stephen!

0 Karma

Stephen_Sorkin
Splunk Employee
Splunk Employee

The best way to do this is to use the fillnull command to make the desired fields dense. In this case, you could try:

... | fillnull value=NULL person infection | top person by infection
Get Updates on the Splunk Community!

Enhance Your Splunk App Development: New Tools & Support

UCC FrameworkAdd-on Builder has been around for quite some time. It helps build Splunk apps faster, but it ...

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...