Getting started with queries

Queries allow you to create and save a set of parameters that find desired items, which can be used throughout the platform. As new items are added, removed, or changed in Perygee the list of items in a query will be dynamically updated. Let’s say, for example, you create a query for high priority assets that’s defined by the type of asset, vendor, and where it’s installed. When you create a new automation or dashboard you can quickly choose the query for high priority assets rather than trying to remember all the attributes and conditions to filter by.

Creating a new query
First, navigate to the admin console by clicking the “Admin console” text button from the left side panel or by clicking the Perygee logo in the top left. Then click “Queries” from the left menu. If you’re already in the admin console, make sure “Queries” is selected.

From there, click the “New query” button in the top right. This will open a new page where you can edit the properties of a query including the name, icon, and item types to include. You can also add conditions that help specify what items are included in the query such as “Vendor” is equal to “Phillips.”

Viewing query data
After you create a query you can view the data from the home page. From the left menu you will see a category header called “Queries” and below that are a list of the queries you have created. Select one to view a spreadsheet-style table with all the data that matches your query parameters.

Note that any changes made inside the table to an item’s values will be reflected in all other queries where this item appears.

Editing a query
From the admin console, select “Queries” from the menu on the left. From the “Actions” column click the “Edit” button to open the Query Editor. Make and save your changes.