Using queries [Web console]

Queries are customized searches of core databases. Queries help you manage your network by allowing you to search for and organize devices in the core database based on specific system or user criteria.

For example, you can create and run a query that returns only devices with a processor clock speed of less than 2 GHz, or with less than 4 GB of RAM, or with a hard drive of less than 80 GB. Create one or more query statements that represent those conditions and relate statements to each other using standard logical operators. When the queries are run, you can print the results of the query, and access and manage the matching devices.

In Endpoint Manager you can create database queries for devices in your core database, and you can create LDAP queries for devices located in other directories.

In the Web console, you can create core database queries using the Queries tool. You create LDAP queries with the Directory manager tool.

Viewing available queries

The Custom queries page displays a list of queries that you have created, either in the Endpoint Manager network view or in the Web console.

To view available queries
  1. In the Web console toolbox, click Reporting > Queries.
  2. Expand the groups (My queries, Public queries, or All queries) to find a query.
  3. Right-click a query to edit, delete, or run it.

Running queries in the Web console

To run a query
  1. In the Web console toolbox, click Reporting > Queries.
  2. Expand the groups (My queries, Public queries, or All queries) to find a query.
  3. Select the query and click the Run button on the toolbar.

    The query results are displayed in the tool pane.

  4. To print the query results, click the Print view button on the toolbar. The complete query results are listed in a table format. Use your browser's Print feature to print the list.
  5. To save the query results to a CSV (comma-separated value) file, click the Save as CSV button on the toolbar and specify a location to save the file.
  6. To view a brief inventory summary of a device in the query results, right-click the device and click View computer.

NOTE: If the query list spans multiple pages, use the arrows at the top right of the page to navigate between pages. Enter the number of items to display per page and click Set.