binary_all_and() (aggregation function)

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft Sentinel

Accumulates values using the binary AND operation for each summarization group, or in total if a group is not specified.

Note

This function is used in conjunction with the summarize operator.

Syntax

binary_all_and (expr)

Learn more about syntax conventions.

Parameters

Name Type Required Description
expr long ✔️ The value used for the binary AND calculation.

Returns

Returns an aggregated value using the binary AND operation over records for each summarization group, or in total if a group is not specified.

Example

The following example produces CAFEF00D using binary AND operations:

datatable(num:long)
[
  0xFFFFFFFF, 
  0xFFFFF00F,
  0xCFFFFFFD,
  0xFAFEFFFF,
]
| summarize result = toupper(tohex(binary_all_and(num)))

Output

result
CAFEF00D