Use the functions provided in these editors to write formulas:
Situation, Query, Properties Filters tab, and Properties Thresholds
tab.
Formula function types
With over a dozen cell and group functions available, you
can build sophisticated filters for reporting only what matters to
you, thus saving time and network resources. Likewise, you can build
thresholds in table views and conditions in situations that trigger
alerts to keep you informed of important changes in your managed network.
Attribute and attribute group characteristics
Formula functions treat attributes as numeric, text or
timestamp. Attributes also have other characteristics that further
categorize them and inform your choice of formula function or query-based
view..
Boolean AND and OR
The tabular editors work
with Boolean AND
and OR logic.
Formula editor menu
The formula editor pop-up menu has functions
for editing the expressions, inserting rows, and deleting rows and
columns.
Cell functions
Use the cell formula functions to add filters to queries
and query-based views, and to set thresholds for situations and query-based
views. The functions that are available depend on the type of attribute
(numeric, text, or time) and in which editor you are working: Query,
Situation, or Properties (Filters and Thresholds tabs).
Group functions
Use the group functions in the Query editor or Situation
editor for attribute groups that return multiple rows of data or a
single-row attribute group that has been configured for historical
data collection. With the exception of COUNT, which can be used by
all attribute types, group functions are available only for numeric
attributes.