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!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...