Maxoutputcolumns
Query
//Using the maxoutputcolumns. Overrides the default maximum number of columns a query is allowed to produce.
set maxoutputcolumns=4677;
search "rotrent"
| distinct $tableExplanation
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.