Splunk Search

Why is ISNULL functionality not working?

Keerthi
Path Finder

Keerthi_0-1681721858028.png

I am trying to get the data only when my lastlogon(field name) is Null. but the above query is still giving me data for both Null and non Null values.

Labels (1)
0 Karma

woodcock
Esteemed Legend

Fields are case sensitive and also sometimes "empty" (i.e. == "").  You can check for both like this:

(isnull(LASTLOGON) OR LASTLOGON=="")

ITWhisperer
SplunkTrust
SplunkTrust

Field name are case-sensitive - try this

| where isnull(LASTLOGON)
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 ...