NQL list

A list clause allows you to specify which fields you want to select.

Syntax

...
| list <field_1>, <field_2>, <metric_1>, <metric_2> ...

Example

Select the name and the type from the users table.

users during past 7d
| list username, type

Name	Type
Hemi Charmian	LOCAL_USER
Wangchuk Mirjam	LOCAL_ADMIN