Reference
Length
The length function returns the length of a string.
Updated 2026-08-17
Length
The length function returns the length of a string. The following illustrates the syntax of the length() function:
Stream=AUTHENTICATION | groupby user | select user, length(user)
Here,
- Stream is Firewall
- Groupby function allows to organize similar data into groups i.e. User.
- Select function helps you to retrieve records from one or more tables, the records retrieved are known as a result set.
- The
length (field)function returns the length of the field value.
In this example, on execution it should retrieve all fields for each event where stream is Authentication; it retrieves the length of the field value. The output is shown as below:

Related
Was this page helpful?