Dell Vizioncore Podręcznik Użytkownika Pobierz pdf (Strona 91)

Queries 91

Creating a Query in vFoglight

Combining And, Or, and Not Conditions

By using nested combinations of And, Or and Not, you can create complex conditions,

such as including a Host if:

• Its name is MainServer or SecondServer.

• There are no events under it.

The following example displays how the Where section of a query is set.

The And clause contains the Or and the Not clauses. The Or clause itself contains the

two comparison clauses, and the Not clause contains an Is Set clause.

Sequence of Evaluation

In a complex query, the selected data objects are subjected to the different parts of the

query in the following order:

The data objects are restricted based on Where - if present.

They are then sorted based on Order By - if present.

Some are then selected based on Filter Results Based on Top N - if present.

The remaining data objects are aggregated (if aggregations are present).

Note For more information about Queries, see the Web Component Tutorial.

Creating New Queries

The New Query dialog lets you create a new query or a copy of an existing query.

To create a new query:

Select Configuration > Definitions in the navigation panel.

1 2 ... 86 87 88 89 90 91 92 93 94 95 96 ... 167 168

Brak uwag

Dell Vizioncore Podręcznik Użytkownika Strona 91