The Filter Results Based on Top N property lets you restrict the results of a query. You can restrict the results to the first N or, conversely, exclude only the first N. For example, you may only want all but the first five items of the results from the query. This function is enabled by selecting the Filter results based on top N? check box.
The Value of N must be a number. You can set this using one of two options:
• |
Specific Value, where you enter a number greater than 0. |
• |
From Parameter, where you can select a Required Parameter from the drop-down list and use the value. |
The Results to Include lets you restrict the results using one of two options:
• |
Only the Top N, where only the first N results are returned. |
• |
Everything except the Top N, where everything except the first N results are returned. |
Selecting Everything except the top N may be useful in conjunction with an aggregation operation where you use one query to get an average of the top N, and you want to use another query to get an average of the rest of the data that are not in the top N.
Order By keys control the sorting of the data objects returned by the query.
If you are sorting on a metric property, such as cpuUsage under Hosts, the algorithm automatically sorts on the metric's current/value property.
1 |
Click the button under Order By. |
2 |
Select the Path from the drop-down tree. |
3 |
1 |
Click the button under Where. |
• |
Comparison: Compare by Path, Specific value, or From Parameter with Path. Comparisons can be one of equals, not equals, is less than, is less than or equals, is greater than, is greater than or equals, like, matches or in. |
• |
Is Set: Choose a path to check if it is set. |
• |
Sub Type is: True if the sub type of the object is as specified. |
• |
And: Logical operator whose operands may be any of the types in this list |
• |
Or: Logical operator whose operands may be any of the types in this list |
• |
Not: Logical operator whose operands may be any of the types in this list |
You can configure the following different types of conditions.
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center