Functional Expressions in OpManager are powerful data transformation functions that allow you to convert raw monitoring data into more meaningful and useful formats. These expressions enable you to apply predefined transformations to output values, such as converting data types between String and Numeric formats, temperature readings from Celsius to Fahrenheit, transforming storage metrics from Bytes to GB,..etc.
OpManager provides several default functional expressions making it easier to standardize monitoring data. You can choose to either store the transformed data permanently or use it solely for alerting purposes. Currently, this can be done when creating custom SNMP monitors in OpManager.
If the provided functional expressions don't meet your requirements, you can also create your own functional expression using the "Custom Output Processor" option by defining your own logic for processing the data from this page.
The following table lists the functional expressions available in OpManager:
| Name | Description | Example |
|---|---|---|
| String To Numeric | Converts and returns the numeric equivalent of the given string input value(s). | Input: "12345" Output: 12345 |
| Numeric To String | Converts and returns the string (text) equivalent of the given numeric input value(s). | Input: 99.99 Output: "99.99" |
| Parse Number From String | Identifies and extracts numeric data from the input string and returns its decimal equivalent value. | Input: "Price: $1,299.99 USD" Output: 1299.99 |
| Replace Using Regex | Replaces parts of the input string that match a specified regular expression (regex) pattern with a replacement string; numeric final results convert to decimal. | Input: CPU - 60% Pattern: \D+ Replace: (empty)Output: 60 |
| Round Up | Rounds the input numeric value(s) upward to the nearest whole number and returns the result. | Input: 4.1 Output: 5 |
| Round Down | Rounds the input numeric value(s) downward to the nearest whole number and returns the result. | Input: 4.9 Output: 4 |
| Remove N Chars From Start | Removes a specified number of characters from the beginning of the input string; numeric final results convert to decimal. | Input: "PRD-12345" Output: 12345 |
| Remove N Chars From End | Removes a specified number of characters from the end of the input string; numeric final results convert to decimal. | Input: "120ms" Output: 120 |
| Length | Calculates and returns the number of characters in the input string. Works for text strings as well as numeric values including decimals and special characters. | Input: "Hello" Output: 5 |
| Celsius To Fahrenheit | Converts temperature from Celsius to Fahrenheit using the formula °F = °C × 9/5 + 32. | Input: 25 Output: 77 |
| Fahrenheit To Celsius | Converts temperature from Fahrenheit to Celsius using the formula °C = (°F - 32) × 5/9. | Input: 77 Output: 25 |
| Sum Of Column Values | Calculates and returns the total sum of all numeric values from the input instances. | Input: [10, 20, 30, 40] Output: 100 |
| Average Of Column Values | Calculates and returns the arithmetic mean (average) of all numeric values from the input instances. | Input: [10, 20, 30] Output: 20 |
| Row Count | Calculates and returns the total number of rows present in the input instances. | Input: [row1, row2, row3, row4, row5] Output: 5 |
| Column Minimum Value | Finds and returns the minimum (smallest) value from the input instances. | Input: [5, 7, 2, 9] Output: 2 |
| Column Maximum Value | Finds and returns the maximum (largest) value from the input instances. | Input: [5, 7, 2, 9] Output: 9 |
| Bytes To KiloByte | Converts the input value(s) from bytes to kilobytes (÷ 1024) and returns the result. | Input: 1024 Output: 1 |
| Bytes To MegaByte | Converts the input value(s) from bytes to megabytes (÷ 1,048,576) and returns the result. | Input: 1048576 Output: 1 |
| Bytes To GigaByte | Converts the input value(s) from bytes to gigabytes (÷ 1,073,741,824) and returns the result. | Input: 1073741824 Output: 1 |
| Bytes To TeraByte | Converts the input value(s) from bytes to terabytes (÷ 1,099,511,627,776) and returns the result. | Input: 1099511627776 Output: 1 |
| KiloByte To MegaByte | Converts the input value(s) from kilobytes to megabytes (÷ 1024) and returns the result. | Input: 1024 Output: 1 |
| KiloByte To GigaByte | Converts the input value(s) from kilobytes to gigabytes (÷ 1,048,576) and returns the result. | Input: 1048576 Output: 1 |
| KiloByte To TeraByte | Converts the input value(s) from kilobytes to terabytes (÷ 1,073,741,824) and returns the result. | Input: 1073741824 Output: 1 |
| MegaByte To GigaByte | Converts the input value(s) from megabytes to gigabytes (÷ 1024) and returns the result. | Input: 1024 Output: 1 |
| MegaByte To TeraByte | Converts the input value(s) from megabytes to terabytes (÷ 1,048,576) and returns the result. | Input: 1048576 Output: 1 |
| Gigabyte To TeraByte | Converts the input value(s) from gigabytes to terabytes (÷ 1024) and returns the result. | Input: 1024 Output: 1 |
| Minutes To Hour | Converts the input value(s) from minutes to hours (÷ 60) and returns the result. | Input: 90 Output: 1.5 |
| Minutes To Days | Converts the input value(s) from minutes to days (÷ 1440) and returns the result. | Input: 1440 Output: 1 |
| Hour To Days | Converts the input value(s) from hours to days (÷ 24) and returns the result. | Input: 48 Output: 2 |
| Hexa To Decimal | Converts the input value(s) from hexadecimal format (base 16) to decimal format (base 10) and returns the result. | Input: "FF" Output: 255 |
| Octa To Decimal | Converts the input value(s) from octal format (base 8) to decimal format (base 10) and returns the result. | Input: "755" Output: 493 |