Building a Query from Asset Manager Indexed Data

• Attribute types of the tables, which are associated with your selected model and later become column heads, display like this in the Query Builder.

• Select a model such as devicemodel, and then drag attributes of interest from the column on the left to the Fields box.

• The attributes become column-heads in the resulting report.

• You can also filter the report results. So far, the example requests all the records in which the DNS name is not null (i.e., all records specifying a DNS name).

• You can narrow the results set. 

• At least one port is open.

• Additionally, not all ports were closed. You can next the filters. This one further specifies that devices without closed ports (i.e., devices with open ports or devicecloseports is null) be returned.

• To run the query, press shift+enter.

• Re auto-refesh, it's not recommended unless you are sitting at dashboard and have a need.  Otherwise it could potentially affect network performance.

• Comments and tags are shared among all those w permissions to view report.