Universal Device Poller - Define what should be calculated by the transform
Formula
The formula is the definition of what should be calculated within the transform to compute the performance measure that you want.
Define formulas
Transforms are defined using basic algebraic operations and exponents. Available pollers serve as variables.
Type a formula for calculating the transform into the Formula field or use the Add Function button.
For frequently used formulas, see Universal Device Poller - common calculations for poller transforms
In formulas, you can use the following items:
- Standard mathematical operations
- Mathematical constants e and π, as
E()
andPI()
, respectively - Poller transformation formulas are also nestable.
Example: {poller1}+{poller2}
Example: avg(min({poller1},{poller2}),max({poller3},{poller4}))
The example returns the average of two poller comparisons.
Add a function
- Click Add Function, and select an algebraic function.
- Click within the function parentheses.
- Click Add Poller, and select the poller that should be used in the calculation.
Insert poller names within the parentheses of the selected function.
If a selected function operates on multiple pollers, add all pollers within the parentheses, separate them by a comma and a single space.
Example:
avg({poller1}, {poller2}, {poller3})
Available functions
Click Add Function to see the list of functions you can use within the formula.
Poller Transformation |
Definition |
---|---|
Average |
An average of the results of multiple pollers |
Minimum |
The minimum of multiple poller results |
Maximum |
The maximum of multiple poller results |
Truncate |
Truncates a polled value to a designated number of decimal places. Example: |
ColumnAverage |
An average of the column values in a polled table |
ColumnMinimum |
The minimum of a column of values in a polled table |
ColumnMaximum |
The maximum of a column of values in a polled table |
ColumnSum |
The sum of a column of values in a polled table |
Temperature > Celsius to Fahrenheit |
The Fahrenheit equivalent of a poller result originally presented in Celsius |
Temperature > Fahrenheit to Celsius |
The Celsius equivalent of a poller result originally presented in Fahrenheit |
X to Kilobyte |
The number of Kilobytes equivalent to a poller result originally presented in Bytes |
X to Megabyte |
The number of Megabytes equivalent to a poller result originally presented in Bytes |
X to Gigabyte |
The number of Gigabytes equivalent to a poller result originally presented in Bytes |
X to Terabyte |
The number of Terabytes equivalent to a poller result originally presented in Bytes |
Kilobyte to Megabyte |
The number of Megabytes equivalent to a poller result originally presented in Kilobytes |
Kilobyte to Gigabyte |
The number of Gigabytes equivalent to a poller result originally presented in Kilobytes |
Kilobyte to Terabyte |
The number of Terabytes equivalent to a poller result originally presented in Kilobytes |
Megabyte to Gigabyte |
The number of Gigabytes equivalent to a poller result originally presented in Megabytes |
Megabyte to Terabyte |
The number of Terabytes equivalent to a poller result originally presented in Megabytes |
Gigabyte to Terabyte |
The number of Terabytes equivalent to a poller result originally presented in Gigabytes |
Parse |
Using C# regular expression syntax, retrieves the first match for a provided poller result in a string poller result. Example that returns 55:
For more information about C# regular expressions, see the appendix Regular Expression Pattern Matching. |