Cortex XDR XQL earliest aggregate returns the first field value found in the dataset with the matching criteria.
comp first(<field>) [as <alias>] by <field_1>,<field_2>
firstaggregation is a comp function that returns the first value found for a field in the dataset that has matching values for the fields identified in the
Return the first timestamp found in the dataset for any given
action_total_downloadvalue for all records that have matching values for their
dataset = xdr_data | fields _time, actor_process_image_path as Process_Path, actor_process_command_line as Process_CMD, action_total_download as Download | filter Download > 0 | comp first(_time) as download_time by Process_Path, Process_CMD
Recommended For You
Recommended videos not found.