Simplify

Use the simplify command to reduce query output to its key patterns, making large result sets easier to interpret.

Usage: <field> | simplify <field> <rows> <number>

Description: Identify the rows and columns carrying the highest information level.

Example: alerts | simplify

Figure 1. Query result: alerts | simplify

Vantage IQ query result showing the rows and columns with the highest information content in alert data

Example: assets | simplify rows 10

Figure 2. Query result: assets | simplify rows 10

Vantage IQ query result showing the top 10 most informative rows from asset data