Use the search language
The searches that you have run to this point have retrieved events from your Splunk index. You were limited to asking questions that could only be answered by the number of events returned.
For example, you ran the following search to determine how many simulation games were purchased:
sourcetype=access_* status=200 action=purchase categoryId=simulation
To find this number for the days of the previous week, you need to run it against the data for each day of that week. To see which products are more popular than the other, run the search for each of the eight
categoryId values and compare the results.
Splunk developed the Search Processing Language (SPL) to use with Splunk software. SPL encompasses all the search commands and their functions, arguments, and clauses. One way to learn the SPL language is by using the Search Assistant.
Learn with the Search Assistant
There are two modes for the Search Assistant: Compact and Full. The default mode is Compact, which you were introduced to in the Basic searches and search results topic in this tutorial.
This section shows you how to change the Search Assistant mode. You will use the Search Assistant to learn about the SPL and to construct searches.
- Select the Account menu.
Splunk platform Step Example Splunk Enterprise Select Administrator > Account Settings. Splunk Cloud Select Your_Name > User Settings.
- Scroll down to the Search section and change the Search assistant to Full.
- The Full mode provides more information as you type commands in the Search bar.
- Click Save.
Let's explore the benefits of the Full mode and creating searches using the SPL commands.
- Click App > Search & Reporting to return to the Search app.
- Type s in the Search bar.
- Select the following search from the Matching Searches list, or type the search into the Search bar.
sourcetype=access_* status=200 action=purchase
- After action=purchase, type a pipe character ( | ) into the Search bar.
- The pipe character indicates that you are about to use a command. The results of the search to the left of the pipe are used as the input to the command to the right of the pipe. You can pass the results of one command into another command in a series, or pipeline, of search commands.
- You want the search to return the most popular items bought at the Buttercup Games online store.
- Under Common Next Commands, select top.
categoryIdinto the Search bar.
- The following search is the complete search string.
sourcetype=access_* status=200 action=purchase | top categoryId
- The search criteria before the pipe character,
sourcetype=access_* status=200 action=purchase, locates events from the access control log files, that were successful (HTTP status is 200), and that were a purchase of a product.
- The search criteria after the pipe character,
top categoryId, takes the events located and returns the
categoryIdfield for the most common values.
- Run the search.
- The results of the
topcommand appear in the Statistics tab.
View results in the Statistics tab
top command is a transforming command. Transforming commands organize the search results into a table. Use transforming commands to generate results that you can use to create visualizations such as column, bar, line, area, and pie charts. We will talk more about visualizations later in this tutorial.
In this search for successful purchases, seven different category IDs were found. The list shows the category ID values from highest to lowest, based on the frequency of the category ID values in the events.
Many of the transforming commands return additional fields that contain useful statistical information. The
top command returns two new fields,
countfield specifies the number of times each value of the
categoryIdfield occurs in the search results.
percentfield specifies how large the count is compared to the total count.
View and format results in the Visualization tab
You can also view the results of transforming searches in the Visualizations tab, where you can format the chart type.
- Click the Visualization tab.
- By default, the Visualization tab opens with a Column chart.
- Click Column Chart to open the visualization type selector.
- Column, Bar, and Pie charts are listed as the Recommended chart type for this data set.
- Select the Pie chart.
- Now, your visualization looks like the following pie chart.
- Next to the visualization drop-down list, click Format.
- On the General tab next to Drilldown, click Yes.
- Then close the dialog box.
- The Drilldown setting lets you delve into the details of the information in the tables and charts on the Visualizations tab.
- Hover over each slice of the pie to see the
percentagevalues for each
- Click on a slice, such as STRATEGY.
- Because Drilldown is enabled, the criteria
categoryId=STRATEGYis added to your search string, replacing the
topcommand. The search runs again.
Learn about correlating events with subsearches.
Use fields to search
Use a subsearch
This documentation applies to the following versions of Splunk® Enterprise: 6.5.0, 6.5.1, 6.5.2, 6.5.3, 6.5.4, 6.5.5, 6.5.6, 6.5.7, 6.5.8, 6.5.9, 6.5.10