isnull

Returns true if the argument is null, otherwise false.

Spec

isnull(arg0)

Parameters

arg0 - The value to check for null.

Return Value

A boolean: true if arg0 is null, false otherwise.

Example

datatable(val:int64)[1, 3]
| extend is_missing = isnull(val)

val	is_missing
1	false
3	false

Filter to null rows:

events
| where isnull(payload)