XQL Language Features - Reference Guide - Cortex XSIAM - Cortex - Security Operations

The Cortex Query Language (XQL) enables you to query for information contained in a wide variety of data sources in Cortex XSIAM for rigorous endpoint and network event analysis. Queries require a dataset, or data source, to run against. In a dataset query, unless otherwise specified, the query runs against the xdr_data dataset, which contains all raw log information that Cortex XSIAM collects. In XDM queries, the xdr_data dataset is mapped to the XDM, by default, with some data mapping exceptions. For both types of queries, you can also import data from third parties and then query against those datasets as well.

You submit XQL queries to Cortex XSIAM using the Incident Response → Investigation → Query Builder user interface.

XQL is similar to other query languages, and it uses some of the same functions as can be found in many SQL implementations, but it is not SQL. XQL forms queries in stages. Each stage performs a specific query operation and is separated by a pipe (|) character. To help you create an effective XQL query with the proper syntax, the query field in the user interface provides suggestions and definitions as you type. For example, the following dataset query uses three stages to identify the dataset to query, identify the field to be retrieved from the dataset, and then set a filter that identifies which records should be retrieved as part of the query:

dataset = xdr_data 
| fields os_actor_process_file_size as osapfs 
| filter to_string(osapfs) = "12345"

XQL supports: