Working with Queries to Populate Device Groups, and Run Reports
Good afternoon everyone,
Queries are the most powerful tools that you can have within Client Management 12.x, as it allows you to populate information based on the criteria that you are looking for. There are two types of Queries for Client Management:
- Criteria based queries
- Free Queries
Criteria based queries allows you to select the items that you are looking for from the GUI itself. Click a query, then select “Add Criterion”.
From the Select Criterion window, you can choose the items that you want to display based on the type of query. In this example, the type of query is a device query, but you can choose to do any number of queries depending on what you are trying to accomplish.
A free query is a query that you would build yourself with SQL. Here is an example:
You can write a SQL statement to return the results that you’re looking for. Keep in mind that The SELECT of the query may not contain operators like AVG, COUNT, MAX, MIN, and SUM or SQL commands like UNION, INTERSECT, EXCEPT, MINUS, and you cannot use * after the select Statement. This is because the system needs to know specifically what you are trying to use. In this example, this is a Free Query for the type Devices and how it begins:
Once the query is built and you have the results, you can use these queries on a number of things. The most commonly used items for Queries are on Device Population and reporting.
If you want to build a group of devices that are using Notepad++ here is what you need to do:
- Select Device Groups
- Click on the button to create a Device Group
- Give the group a name, in this example “Devices with notepad++”
- Click OK.
The end result would show something like this:
Once this is done, to add the query to the group:
- Expand “Devices with Notepad++”, or the name you have given to the group.
- Select Dynamic Population
- Select Queries
- Click on the chain to assign a query
- Select the query you built with the results you were looking for.
- Make sure to either select All Devices, or Only Devices with an Agent if you wish to filter further.
Once the device group refreshes, you will see the results of your query being populated here. Since this is a dynamic population, any changes to the group, like in this example a machine removes Notepad++, on the next update the machine will disappear from the group.
These dynamic queries can be useful in cases where you want the results to update as changes occur. A common use for this is to populate discovered or unmanaged devices without an agent so that you can then install the agents on those devices. As the Agents get installed, the machines would slowly get removed from the group as it updates.
For any other questions with regards to these steps, or if you require immediate assistance please feel free to contact us at firstname.lastname@example.org or via telephone at 1-844-359-2278