Splunk® Enterprise

Search Manual

Splunk Enterprise version 7.0 is no longer supported as of October 23, 2019. See the Splunk Software Support Policy for details. For information about upgrading to a supported version, see How to upgrade Splunk Enterprise.
This documentation does not apply to the most recent version of Splunk® Enterprise. For documentation on the most recent version, go to the latest release.

Drill down on table row or cell information

After running a transforming search that returns a table in the Statistics tab, click on a row or cell of that table to run different kinds of secondary drilldown searches.

The following drilldown search actions focus on the field-value pairs represented by a table row or cell.

Drilldown action Description Time range Result
View events Run a search that shows only the events from the original dataset that include the field-value pairs. Discard all piped search commands. Same as the original search, unless you are clicking on a cell or row that represents a specific span of time, in which case the drilldown search uses that span as its time range. An event list similar to the one returned by the original search, filtered to include only events that have the field-value pairs.
Other events Run a search that shows only the events from the original dataset that do not include the field-value pairs. Discard transforming search commands and any commands that follow them. Same as original search. An event list similar to the one from the original search, filtered to include only events that do not have the field-value pairs.
Exclude from results Rerun the original search including all piped search commands. Omit events that include the field-value pair. Same as original search. A table similar to the one returned by the original search, minus events containing the field-value pair.
New search Run a new search that focuses exclusively on the field-value pair. No additional values or search commands are included. Same as original search. A list of all events within the time range that have the field-value pair.
Narrow to this time range Rerun the original search including all piped search commands. The time range represented by the selected row or cell. A table similar to the one returned by the original search, but only for events that fall within the time range represented by the clicked row. The new table is broken out into rows representing time spans within the new time range.

Run a drilldown search on a table row or cell

1. In the Search & Reporting app, run a transforming search or report that returns a table in the Statistics tab.

2. Click Format and select the appropriate value for Drilldown.

Select Row if you want to run a drilldown search on a row.
Select Cell if you want to run a drilldown search on a cell.

Tablesearch format dd options.png

3. Click a table row or cell that you would like to run a drilldown search on.

A list of drilldown search options appears. The list also indicates the field-value pairs that are the focus of the drilldown search options. The option list also indicates whether the drilldown search will use a specific time range.
The set of options you see depends on a variety of factors. See "Drilldown search options for rows" and "Drilldown search options for cells"

4. Click a drilldown search option.

Run the drilldown search in the current tab and replace your current search, or run the drilldown search in a new tab and leave your current search results intact. To run the search in the current tab, click the option text. To run the search in a new tab, click the Open In New Tab icon Secsrch run in sep tab icon.png for the option.

Drilldown search options for rows

There are two possible sets of drilldown search options for rows.

When you click on a row where the first column represents a value of _time, meaning that the row represents a timespan, you see two drilldown search options when you click on the row.

  • View events
  • Narrow to this time range

Tablesecsrch row time.png

When you click on a row where the first column represents a field-value pair, you see these drilldown search options when you click on the row. The drilldown searches use each field-value pair represented by the row.

  • View events
  • Other events

Tablesearch row not time.png

Drilldown search options for cells

The set of drilldown search options you see when you click on a cell differ depending on a variety of factors.

The cell represents a timespan. When you click on a row cell that displays a value of _time, meaning that it represents a span of time, you see two drilldown search options.

  • View events
  • Narrow to this time range

Tablesecsrch cell time.png

The cell represents a split row field value. You see this for cells in tables where the columns represent fields, and you are clicking in a cell that is not in the first column. You see four drilldown search options for the field-value pair represented by the column title and the cell value.

  • View events
  • Other events
  • Exclude from events
  • New search

In addition, you see two drilldown search options for the combination of the field-value pair represented by the cell you selected and the other field-value pairs preceding it on its row.

  • View events
  • Other events

Tablesecsrch cell split row.png

The cell represents a split column value. You typically see this in tables where the first column is a time range or split row field and the other columns represent values of another field. The split column cells usually contain a count or similar numeric value.

  • Exclude from events (for the field-value pair represented by the column)
  • View events (for the field-value pair represented by the column and the field-value pair or time range represented by the row)

Tablesecsrch cell split column.png

The cell represents an event count or percentage and is not a split column value. You see two drilldown search options for the combination of the field-value pairs in the cells preceding this cell along its row.

  • View events
  • Other events

Tablesecsrch cell count or pct.png

Drilldown searches for charts and visualizations

You can also click on elements of charts and visualizations to run drilldown searches. For more information see Use drilldown for dashboard interactivity in Dashboards and Visualizations.

Last modified on 17 April, 2018
Compare hourly sums across multiple days   Open a non-transforming search in Pivot to create tables and charts

This documentation applies to the following versions of Splunk® Enterprise: 7.0.0, 7.0.1, 7.0.2, 7.0.3, 7.0.4, 7.0.5, 7.0.6, 7.0.7, 7.0.8, 7.0.9, 7.0.10, 7.0.11, 7.0.13


Was this topic useful?







You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters