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 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 |