count - Reference Guide - Cortex XDR - Cortex

Abstract

Learn more about the Cortex Query Language count function used with both comp and windowcomp stages.

Syntax

comp count([<field>]) [as <alias>] by <field_1>,<field_2> [addrawdata = true|false [as <target field>]]

windowcomp count([<field>]) [by <field> [,<field>,...]] [sort [asc|desc] <field1> [, [asc|desc] <field2>,...]] [between 0|null|<number>|-<number> [and 0|null|<number>|-<number>] [frame_type=range]] [as <alias>]

Description

The count() function is used to return a single count for the number of rows either for a field over a group of rows, where only the number of non-null values found are returned, or without a field to count the number of rows, including null values. The function syntax and application is based on the preceding stage:

When the count aggregation function is used with a comp stage, the function returns one of the following:

With a field: Returns a single count for the number of non-null rows, for all records that contain matching values for the fields identified in the by clause.
Without a field: Counts the number of rows and includes null values.

In addition, you can configure whether the raw data events are displayed by setting addrawdata to either true or false (default), which are used to configure the final comp results. When including raw data events in your query, the query runs for up to 50 fields that you define and displays up to 100 events.

Use count_distinct to retrieve the number of unique values in the result set.

Examples

Return a single count of all values found for the actor_process_image_path field in the group of rows, for all records that have matching values for their actor_process_image_path and actor_process_command_line values. The query calculates a maximum of 100 xdr_data records and includes a raw_data column listing a single value for the results.

dataset = xdr_data
| fields actor_process_image_path as Process_Path, actor_process_command_line as Process_CMD, action_total_download as Download
| filter Download > 0
| limit 100
| comp count(Process_Path) as num_process_path by process_path, process_cmd addrawdata = true as raw_data
| sort desc process_path

count - Reference Guide - Cortex XDR - Cortex - Security Operations

Cortex XDR XQL Language Reference

Syntax

Description

Examples