Check for Values in Array
Use array query filter array:contains()
to check for a value in a flat array
Query
array:contains("incidents[]", value="Cozy Bear")
Introduction
Array query filters are data structure elements that make it possible to define a list of values in a single field. The different array query functions can be used to extract, filter and search data and then index it into an array.
In this example, the
array:contains()
function is used to check if
a given value exists in a given array.
Step-by-Step
Starting with the source repository events.
- flowchart LR; %%{init: {"flowchart": {"defaultRenderer": "elk"}} }%% repo{{Events}} 0[/Filter/] result{{Result Set}} repo --> 0 0 --> result style 0 fill:#ff0000,stroke-width:4px,stroke:#000;logscale
array:contains("incidents[]", value="Cozy Bear")
Checks if the value of
Cozy Bear
exists within the incidents array field. If the array contains the value, the whole event is included in the search result. Event Result set.
Summary and Results
The query is used as a filter to check if a given value exists in a given array within the event set. If the given value does not match any of the values of the array, then the event is excluded from the search result. Arrays are used when ingesting security event logs where fields may have more than one value. If the array contains other values along with the specified value, these are also included in the search results.