KQL Search

Query Details

HomeAI ToolsDevice Query

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.

Details

Rod Trent profile picture

Rod Trent

Released: April 6, 2023

Tables

The table name used in the query is not provided.

Keywords

Devices,Intune,User

Operators

setmaxoutputcolumnssearchdistinct

Actions