Query Details

Maxoutputcolumns

Query

//Using the maxoutputcolumns. Overrides the default maximum number of columns a query is allowed to produce.

set maxoutputcolumns=4677;
search "rotrent"
| distinct $table

Explanation

The query is using the "maxoutputcolumns" setting to change the maximum number of columns that can be displayed in the query results. It then searches for the term "rotrent" and returns only the distinct values from the specified table.