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.

Building a Query

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

These attributes look like this in the SQL view.

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.  This example shows how to retrieve devices in which  at least one port was open and not all ports were closed.

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.  Otheriwse it could pontially affect network performance.

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

__________

__________________________

Here's an example of the query elements you would use to find all devices that have either ports 22 or port 443 open. If you have other "red ports" that you want to keep an eye on, you can import your organization's watchlist of ports and then produce a report that specifies all devices having those open.