appendcols
appendcols
Synopsis
Appends the fields of the subsearch results to current results, first results to first result, second to second, etc.
Syntax
appendcols [override=bool|subsearch-options]* subsearch
Required arguments
- subsearch
- Description: A search pipeline. Read more about how subsearches work in the User manual.
Optional arguments
- override
- Datatype: <bool>
- Description: If option override is false (default), if a field is present in both a subsearch result and the main result, the main result is used.
- subsearch-options
- Syntax: maxtime=<int> | maxout=<int> | timeout=<int>
- Description: Controls how the subsearch is executed.
Subsearch options
- maxtime
- Syntax: maxtime=<int>
- Description: The maximum time (in seconds) to spend on the subsearch before automatically finalizing. Defaults to 60.
- maxout
- Syntax: maxout=<int>
- Description: The maximum number of result rows to output from the subsearch. Defaults to 50000.
- timeout
- Syntax: timeout=<int>
- Description: The maximum time (in seconds) to wait for subsearch to fully finish. Defaults to 120.
Description
Appends fields of the results of the subsearch into input search results by combining the external fields of the subsearch (fields that do not start with '_') into the current results. The first subsearch result is merged with the first main result, the second with the second, and so on. If option override is false (default), if a field is present in both a subsearch result and the main result, the main result is used. If it is true, the subsearch result's value for that field is used.
Examples
Example 1: Search for "404" events and append the fields in each event to the previous search results.
... | appendcols [search 404]See also
Answers
Have questions? Visit Splunk Answers and see what questions and answers the Splunk community has using the appendcols command.
This documentation applies to the following versions of Splunk: 4.1 , 4.1.1 , 4.1.2 , 4.1.3 , 4.1.4 , 4.1.5 , 4.1.6 , 4.1.7 , 4.1.8 , 4.2 , 4.2.1 , 4.2.2 , 4.2.3 , 4.2.4 , 4.2.5 , 4.3 , 4.3.1 , 4.3.2 View the Article History for its revisions.