group by

Synopsis

Groups events according to column values.

Syntax

group by [column_name] (in [Format_Type] format)(["Input_Unit"],)(["Output_Unit"]) (, [column_name] …)  

Required Arguments

column_name

Syntax: <character string>

Description: The name of the column header according to which events are to be grouped.

Optional Arguments

column_name

Syntax: <character string>

Description: The name of additional column headers according to which events are to be sub-grouped. Column names should be comma separated.

Format_Type

Syntax: number, simple, time, date, volume, regexp, expression, query, exception, replace, or useragentdetect

Description: The display format of the column header values in the summary table. See format.

Description

Creates a summary table that categorizes events according to their grouping. Must be preceded by a function.

Examples

Example 1:  

* in log.access | count | group by url  

 Returns the number of events from each URL.