. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1559 6 Supported functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . geographical maps. For more information see the Geomap dashboard widget and geographical maps. Functions Functions for Prometheus histograms It has been possible to collect Prometheus metrics in Zabbix for analyze the collected data without specialized functions. To cover this functionality gap in the new version, rate() and histogram_quantile() functions, producing the same result as their PromQL counterparts

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1573 6 Supported functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . added for hosts, host tags, items, item tags, item preprocessing, trig- gers, trigger tags and functions to lessen synchronization time and database load when configuration is being updated on an already A new AWS by HTTP template is available now. See setup instructions for HTTP templates. Packages SQL scripts have been moved from the /usr/share/doc directory to /usr/share in Zabbix packages. 9 What’s

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1749 6 Supported functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . only the total of hosts, without breakdown by interfaces, has been introduced. Functions New functions New functions have been added for use in trigger expressions and calculated items: • jsonpath() xmlxpath() - returns the XML XPath result. See also: String functions Updated functions Several functions have been updated: • Aggregate functions now also support non-numeric types for calculation. This

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1692 6 Supported functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . mandatory”. TimescaleDB 2.11 support Support for TimescaleDB version 2.11 is now available. Aggregate functions The count_foreach function now returns ’0’ for a matching item in the array, if no data are present overview widgets. 12 What’s new in Zabbix 6.4.7 Aggregate functions The last_foreach function is now also supported in the following aggregate functions: kurtosis, mad, skewness, stddevpop, std- devsamp, sumofsquares

expanding off performance wise. 15 5.2.27 Improved debug layout In the frontend debug functionality, SQL query formatting has been improved for better readability. 5.2.28 Allow deleting trigger dependencies Attention: Order of database file import has been changed - images must be imported before data.sql now. 5.5.3 Improved active agent auto-registration Active agent auto-registration now supports monitoring Frontend improvements • Frontend overall performance was improved by optimising performance checks • SQL query count was reduced and performance improved in IT services and most pages that access trigger

/metrics endpoint with HTTP agent (see description). Microsoft SQL Server • Template DB MSSQL by ODBC - collects metrics from DBMS Microsoft SQL Server via ODBC (see description). IIS • Template App IIS JavaScript code. JavaScript functions for MD5 and SHA256 calculation 27 The functions for MD5 and SHA256 hash calculation have been added to global JavaScript functions. JavaScript memory limit The Zabbix agent 2 items proc.num, proc.cpu.utilization, proc.mem have been updated to use the latest functions intro- duced in Go 1.16 and thus provide better performance. Go version 1.16 or newer is now required

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1691 6 Supported functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . aggregate calculations) • Aggregated items no longer exist as a separate item type (former aggregate functions, such as grpsum, grpavg, etc have been changed to sum_foreach, avg_foreach, etc to be used in calculated supports other expressions as parameters • Item reference is now the first parameter of history functions (as host/item) • Changed syntax for expression macros The outlined changes can be observed in

{host:key.func(param)} macro syntax. Similarly to map labels, only avg(), last(), max() and min() functions with seconds as parameter are supported within this macro in graph names. Value mapping is supported optional parameters in trigger functions. For example, trigger function ”last(#1)” can be written as ”last()”, ”last(#1,1h)” - as ”last(,1h)”. It also works for functions of calculated items. 5.10 Network sensitive and use hys- teresis. All templates have been updated to use suffixes and aggregate functions. All OS templates have been updated to include memory graph. 15 5.20 Network discovery changes

regular items and item prototypes. Substring extraction of low-level discovery macro value Macro functions are now supported with low-level discovery macros, allowing to extract a certain part of the macro field of a trigger prototype: For more information on macro function syntax, see: Macro functions. Macro functions are supported in all locations where low-level discovery macros can be used, except for value. Triggers Time triggers processed by history syncers The processing of time-based trigger functions such as nodata(), date(), dayofmonth(), dayofweek(), time() and now() has been moved from timer

to create a very flexible setup. 5 What’s new in Zabbix 5.2.0 Trigger functions for long-term analytics New trigger functions have been added allowing to compare data from absolute periods (hour, day day, week, month, year) and notify user if there is a significant difference. The new functions are: • trendavg - average of trend values for period • trendcount - count of trend values for period • minimum of trend values for period • trendsum - sum of trend values for period Note that the new functions return a result based on trend values, not history. For example, you may want to know if there