Skip to content

Events Query Language

This domain-specific language can be used to generate search queries that integrate advanded search operators.

Please refer to Elastic Common Schema (ECS) Reference if you need to look up a field available in Sekoia.io.

Example

On the Events page, the following query will match all successful connections to a domain name starting by evil:

event.type:connection AND NOT action.outcome:failure AND destination.domain:evil*

Syntax

A query can contain one or more terms, separated by logical operators.

Each term is composed of a field name, an operator and a literal.

e.g: id:"ALWyJiGeJSiw"

A term without a field name and an operator will search the literal value in all fields.

Literals

Type Description Example
Word Single word value
Phrase A phrase is surrounded by double quotes and matches all words in this exact order "exact phrase"
Numbers For numeric fields 17.23
Wildcards Wildcard characters can be used to match more events. Use ? to match a single character or * to replace any number of characters. evil*
Regular Expressions Regular Expressions can be used to filter for specific values. The regular expression is surrounded by forward slashes (/) /(evil|bad).*/

Note

For regular expressions, do not use ^ and $ which delimits the beginning and the ending of a line.

Operators

Term Operators

Term Operators can be used to customize the search

Operator Description Example
: The field must exactly match the literal. In case the field represents a list, this means that one item of the list must match. event.type:connection
:* The field must have a value. dns.question.name:*
:> The numerical value must be greater than the specified number destination.bytes:>42
:>= The numerical value must be greater than or equal to the specified number destination.bytes:>=42
:< The numerical value must be less than the specified number destination.bytes:<42
:<= The numerical value must be less than or equal to the specified number destination.bytes:<=42
:[X TO Y] The numerical value must be between X and Y destination.bytes:[100 TO 200]

Note

for IP search, :[X TO Y] is available with X and Y as IP ranges e.g. source.ip:[145.0.0.0 TO 145.255.255.255]

Logical operators

Operator Description Example
AND Match if both terms are verified event.type:connection AND action.outcome:success
OR Match if one of the terms is verified source.ip:"1.2.3.4" OR destination.ip:"1.2.3.4"
NOT Inverse the result of the term NOT event.type:connection

Note

Take care, operators need to be uppercase in your query.

Grouping operators

Operator Description Example
() Groups operands event.type:connection AND (source.ip:"1.2.3.4" OR destination.ip:"1.2.3.4")