Edit

Share via

binary_all_and() (aggregation function)

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Accumulates values using the binary AND operation for each summarization group, or in total if a group isn't 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 isn't specified.

Examples

The following example produces CAFEF00D using binary AND operations.

Run the query

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

Output

result
CAFEF00D

Related content