Count and Sort Events by Name

Problem / use case

You want to count how many times each name appears in your logs and then sort the result alphabetically by name. This can be accomplished with the countBy command.

Query

countby name into name_count
| orderby name

Expected output

Variations

To sort by descending frequency instead:

countby name into name_count
| orderby name_count desc

Previous Fuzzy search all fields

Next Bucket longtask durations into performance ranges

Theme

Light

light

dark