You want to find all executions of a file on older Windows operating systems.

When performing advanced hunting, telemetry from individual events (like a ProcessRollup2) often lacks organizational context, such as the host's Operating System version or its location within the Active Directory Organizational Unit (OU) . In the Falcon platform, this metadata is stored in lookup files like aid_master_main.csv. To enrich real-time event data with this contextual information, the lookup() function is the standard and most efficient method within the CrowdStrike Query Language (CQL) .

The lookup function works by mapping a common field—in this case, the Agent ID (aid) —between the event stream and the static CSV file. By specifying include=[Version, OU], the query instructs the engine to append the specific OS version and OU path to every matching process execution event. This allows a hunter to filter for "older Windows operating systems" (e.g., Windows 7 or Server 2008) or focus specifically on OUs containing "Domain Admins" or "Critical Servers." This methodology is a core component of Search and Investigation Tools , as it transforms raw technical data into actionable intelligence. Without the lookup function, an analyst would have only the technical process details without knowing the strategic importance or the underlying vulnerability (OS version) of the target host, significantly hindering the ability to prioritize the investigation.

==========