Create an advanced query
The advanced query feature allows you to build custom queries to enhance your threat hunting activities. Advanced query offers deep visibility into your
CylanceOPTICS
environment, expansive query options, and optimized workflows that allow you to combine related searches to reveal new insights. Advanced query is supported for devices with the CylanceOPTICS
agent version 3.0 or later.
Advanced query relies on the use of EQL syntax. You use EQL to construct queries for events, and the results provide information about the artifacts that were involved in those events. The advanced query UI includes syntax information to help you build EQL queries.
- In the management console, on the menu bar, clickCylanceOPTICS > Advanced Query.
- Do one of the following:TaskStepsCreate a new advanced queryIf you want to use an existing query template to create a new query, clickShow Template Listand click a template, then skip the first step below.
- In the query field, type or paste the EQL syntax for the query. As you type, syntax options and validation messages will display to help you build your query.If you want to save the current query as a template, clickSave As Template. Type a name and description and select whether you want the template to be private or available to all administrators. ClickSave. You can pin, edit, and delete queries from the templates list.
- To set the scope of the query, underSearch devices, clickBy ZoneorBy Device(an icon next to each device indicates whether the device is online). Select one or more zones or devices, then clickSave. If you don't set the scope, the query applies to all zones and devices.
- To set a date and time range for the query, click and configure the range. ClickApply. If you don't set a range, the query applies to all available data.
- Do one of the following:
- If you want to run the query, clickRun Query.
- If you want to schedule the query to run at a specific date and time or on a regular interval, clickSchedule Query. Type a name and description, select whether you want the query to be private or visible to all users, and set the date, time, and optional recurrence settings. If you want to restrict the query to the data that has been collected since the previous run, select theQuery only new datacheck box. ClickSchedule Query.On theScheduled Queriestab you can view and edit scheduled queries and view and export the results. You can have a maximum of 25 queries that are actively running or scheduled to run. Stopped queries or single run queries that have completed do not count towards this limit.
If you want to save query results to view them later from theQuery Snapshotstab, in the results section, click . Type a name and description and select whether you want the results to be private or visible to all users.View a query snapshotOn theQuery Snapshotstab, click a query snapshot.Note that this displays the original results of the query when it was saved and is not a new query. - If you want to filter the query results, do any of the following:
- To filter query results by date and timestamp, click one or more bars of the histogram to filter by that date and time range. Click any bar in the selected range to remove the date and time filter.
- To filter query results by a column, click for that column (for example, Device) and select the filter criteria.
- To filter query results by a value that you specify, click above the query results, then type or paste the value into the search field (for example, a specific timestamp, an event detail value, and so on).
- Expand a result to display details. Click to open a panel that includes event details and information about associated alerts (you may need to scroll to the right in the results window). To filter the query results to show the matches for one or more specific facets, click for those facets. Click the icon again to remove the filter.
- In the query results, expand the menu to view the available actions for each result. Depending on the type of result, this can include:
- Globally quarantine a file. The file appears inSettings > Global List > Global Quarantine, inProtection > Threats, and in theThreatssection of the device details.
- Request and download a file. If path information is available for files associated with other artifact types, you can also download those files. The file is compressed and password-protected to ensure that it is not accidentally executed. The password is “infected". The size limit for file retrieval is 50 MB. Artifacts and files are retained byCylanceOPTICSfor 30 days.
- If you want to pin a result so that it displays with a visual marker if it shows up in subsequent queries, click .
- If you want to export the query results to a .csv file, click . Type a name and description, specify whether you want the exported results to be private or visible to all administrators, and clickExport. You can download the file from theExported Resultstab when it is ready.
- To add a new query, click next to the current query tab.
- To copy an existing query, hover over that query tab and click .