QuestionQ47

VerifiedCQL Querying and Data Analysis

An event contains the following fields:

Question Image

Which CQL query outputs the frequency for each unique combination of ComputerName, UserName, and CommandLine?

Choose two
Explanation

groupBy([ComputerName, UserName, CommandLine]) groups events by the unique combination of all three fields and returns a count for each group. CQL’s default aggregate for groupBy() is count(as=_count), so specifying function=count() explicitly or relying on the default produces the same per-combination frequency.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!