count operator

Applies to: ✅ Azure Data ExplorerAzure MonitorMicrosoft Sentinel

Returns the number of records in the input record set.

Syntax

T | count

Learn more about syntax conventions.

Parameters

Name Type Required Description
T string ✔️ The tabular input whose records are to be counted.

Returns

This function returns a table with a single record and column of type long. The value of the only cell is the number of records in T.

Example

StormEvents | count

For information about the count() aggregation function, see count() (aggregation function).