Elastic Docs ›Elastic Security Solution [8.13] ›Osquery
« Add Osquery Response Actions Run Osquery from alerts »

Run Osquery from investigation guidesedit

Detection rule investigation guides suggest steps for triaging, analyzing, and responding to potential security issues. When you build a custom rule, you can also set up an investigation guide that incorporates Osquery. This allows you to run live queries from a rule’s investigation guide as you analyze alerts produced by the rule.

Requirements

Shows a live query in an investigation guide

Add live queries to an investigation guideedit

You can only add Osquery to investigation guides for custom rules because prebuilt rules cannot be edited.

  1. Go to Rules → Detection rules (SIEM), select a rule, then click Edit rule settings on the rule details page.
  2. Select the About tab, then expand the rule’s advanced settings.

  3. Scroll down to the Investigation guide section. In the toolbar, click the Osquery button (Click the Osquery button).

    1. Add a descriptive label for the query; for example, Search for executables.

    2. Select a saved query or enter a new one.

      Use placeholder fields to dynamically add existing alert data to your query.

    3. Expand the Advanced section to set a timeout period for the query, and view or set mapped ECS fields included in the results from the live query (optional).

      Overwriting the query’s default timeout period allows you to support queries that take longer to run. The default and minimum supported value for the Timeout field is 60. The maximum supported value is 900.

      setup osquery investigation guide
  4. Click Save changes to add the query to the rule’s investigation guide.

Run live queries from an investigation guideedit

  1. Go to Rules → Detection rules (SIEM), then select a rule to open its details.
  2. Go to the About section of the rule details page and click Investigation guide.

  3. Click the query. The Run Osquery pane displays with the Query field autofilled. Do the following:

    1. Select one or more Elastic Agents or groups to query. Start typing in the search field to get suggestions for Elastic Agents by name, ID, platform, and policy.

    2. Expand the Advanced section to set a timeout period for the query, and view or set mapped ECS fields included in the results from the live query (optional).

      Overwriting the query’s default timeout period allows you to support queries that take longer to run. The default and minimum supported value for the Timeout field is 60. The maximum supported value is 900.

  4. Click Submit to run the query. Query results display in the flyout.

    Refer to Examine Osquery results for more information about query results.

  5. Click Save for later to save the query for future use (optional).

    run query investigation guide
« Add Osquery Response Actions Run Osquery from alerts »