Question 210
A security operations shift handoff reports this condition: A weekly report omits Sunday night events because a customized SQL condition uses a different date window than the scheduled report. What is the most appropriate response to the reported operational problem?
Explanation
Correct Answer
The underlying cause is: An extra hard-coded dataset time predicate can conflict with report-wide period parameters and silently exclude records. The correct response is: Align the dataset's time constraints with the report period variables and test boundary timestamps. Confirm by checking: Events at the beginning and end of the intended week are included exactly once in the query.
Incorrect Answers
That intervention addresses report raw logs differ from aggregated counts, where Distinct asset counts and individual event message totals measure different populations and cannot be compared as equal. Here, the relevant failure is instead: An extra hard-coded dataset time predicate can conflict with report-wide period parameters and silently exclude records.
That intervention addresses sql grouping double counts device sessions, where Counting log rows is different from counting distinct affected assets, especially when multiple detections involve the same host. In this question the necessary remedy is “Align the dataset's time constraints with the report period variables and test boundary timestamps”, which this alternative does not provide.
That intervention addresses report scheduling not enabled, where A saved report definition does not automatically run periodically unless its schedule and output settings are enabled. The observed condition is a weekly report omits Sunday night events because a customized SQL condition uses a different date window than the scheduled report; this mechanism addresses another problem.