Device Explorer

This document describes how you can create device queries in the Device Explorer using the Device Query. A query acts as a ruleset for filtering devices to view collections for informational reporting purposes. From the main Devices page, select the Device Explorer tab. Initially, all devices in your zone are listed in the table. Use queries to filter this list of devices.

The following topics are described here:

From the Device Explorer page, you can create and save queries that filter devices into lists according to the criteria in the saved query.

Device Query

From the Device Query, select up to 10 criteria and save the query to filter devices according to your needs. This saved query is available in a query selector and can be reused, or duplicated and amended. A list of devices appears below the query, which can be exported to a CSV file.

Create a query

Select Attributes and find the type you want to add to your query. Refer to the Attributes Reference list for more information about the attributes.

1. Go to the Attributes menu and select from the list of options.

2. Select a Condition. The available conditions depend on the attribute selected.

3. In the Value field, enter a corresponding value to filter by or select from the options, depending on the attribute.

4. Use the operators AND, OR, and NOT, and apply Subsets, as needed.

   • AND lists devices where ALL the criteria specified are true

   • OR lists devices where ANY of the criteria specified are true

   • NOT lists devices where the criteria specified are NOT TRUE

5. Select Save Query. Enter a unique name up to 64 characters in length. The new query can be found in the Saved Queries selector.

You can create a new query from an already existing query. Open the query to use, modify the query as needed. Save using a unique name.

Example queries

Example of a CPU and IP address filter query:

Example of an agent version query:

Delete a query

If you are creating a new query and want to start over, select Clear All. This resets all entries that were made.

To delete a saved query, open the query from the Saved Queries selector and click Delete Query. Confirm your selection. The query is removed from the Saved Queries selector.

View saved queries

You can view a list of queries from the Saved Queries selector. Click the down arrow to open a list of all queries. If this list is empty, you have no save queries.

Show or hide Query details

It is possible to hide the details of a query. To do this, select the arrow above the query details.

When the query details are hidden, a number indicates how many criteria were used to create the query. Select the arrow to show the full details again.

Attributes Reference

Conditions and Values

Depending on the attribute selected, you can select from different conditions. The value field then allows you to enter text or select from corresponding values.

Example of condition selection:

Example of value selection:

Devices Table

You can view the list of devices that have been filtered by the query. The table includes the same data as the list of attributes, which is reflected in the column headers.

You can find data by using the search bar on the devices table. This is a single term search.

Show/hide columns

The devices table has a default setting of data that can be changed. You can hide, show, and rearrange the columns of data in the list of devices.

1. Select Columns to view the complete list of columns available.

2. Drag and drop column names to the position desired. The table adjusts automatically.

3. Select or clear the checkbox for any column to show or hide that data. This has no effect on the results of any export, which includes the full set of data.

Device Details Sidebar

You can view various statuses and basic details about individual devices directly from the Device Explorer > Devices table. By selecting a device, you open the details sidebar where you can directly take action on the individual device.

Interacting with the device details sidebar:

1. From the Devices table, select the corresponding checkbox to view the device details sidebar for a device. 

2. View status and connection details about a device.

3. You can restart, scan, or delete the device directly from the sidebar. Follow any corresponding prompts related to the selected action.

4. You can view the number of Available Patches. 

   • This status indicates if applicable patches have been detected. Note that these are not necessarily associated with a scheduled policy. 

   • To view a list of available patches for a device, click the Device Name to open the Device Details page. Go to the Software section. The Status column lists any available patches. Search for Update Available.

   • It is recommended that you scan the device to ensure that this status is accurate.

The information provided in this sidebar is an excerpt of the details provided on the current Device Details page. For more information about this data, see Device Details Fields. See also What Statuses Found in the Automox Console Mean.

Export the Device List to a CSV File

You can export the results of any query by selecting the Export CSV button. This exported file only includes the devices from the results of the query. The data exported includes the following information (refer to the Attributes Reference for descriptions)

Related Topics

• Managing Devices