An analyst creates a custom XQL query to investigate unusual PowerShell execution across endpoints. The query needs to filter out known administrative scripts based on a lookup list stored in XSIAM. Which XQL command is best suited to enrich or filter the event stream using a lookup table?
Trap 1: parse lookup_table
Incorrect. Parse is used for extracting fields from unstructured text.
Trap 2: filter in_list
Incorrect. While filter is valid, the specific command for table enrichment is lookup.
Trap 3: join
Incorrect. Join is used to combine two datasets, whereas lookup is specifically designed for referencing lookup tables.
- A
parse lookup_table
Why it fails: Incorrect. Parse is used for extracting fields from unstructured text.
- B
filter in_list
Why it fails: Incorrect. While filter is valid, the specific command for table enrichment is lookup.
- C
lookup
Correct. The lookup command matches fields in the query against a stored lookup table in XSIAM for filtering or enrichment.
- D
join
Why it fails: Incorrect. Join is used to combine two datasets, whereas lookup is specifically designed for referencing lookup tables.