sum(last_foreach(/*/give_number?[group="GGG"])) getting from above ( while testing ) : Cannot evaluate expression: no input data for function at " i have host group GGG and item already that gives me a numeric number from item `give_number` .........
Check out the documentation section regarding foreach function filters: www.zabbix.com/documentation/current/en/manual/appendix/functions/aggregate/foreach#item-filter You should try and filter by host groups and/or tags to get the values that you're looking for.
@@zabbix I'm having the same problem. I think the manual is obfuscated or doesn't say what you're looking for. >count(last_foreach(/*/icmpping[{HOST.IP}])=0?[group="Printers"]) Could you tell me the correct formula for this example?
How do I sum with for_each with filter of SSID that is unique. Example I have 10 clients connected to ssid_1, 5 to ssid_2, 1 to ssid_1 on same host. The summations would be 11 for ssid _1 for item.key.ssid[{#SSID}
what if i want create and array|table with values from hosts, not doing calculations? just wanna pick all hosts with same itens and put in a table in grafana
Currently, the top hosts widget can analyze an item across different hosts and display it in a Top/Bottom hosts list, sorted by the item values. We also have plans to add a separate Top items list widget, which will provide a more general data table view of your items. We can't really comment on Grafana, since they do things their own way by collecting values from Zabbix with Zabbix API calls and then aggregating the data for the visualization.
How to monitor paper (from printer) consumption in the form of a histogram (graph) by months and preferably get a summary of the average paper consumption by years (based on accumulated data)? Paper consumption counter data is logged.
You could use SNMP agent item and point it at the correct OID. The data could the be aggregated either by using a calculated item or directly in your Zabbix graphs.
sum(last_foreach(/*/give_number?[group="GGG"]))
getting from above ( while testing ) : Cannot evaluate expression: no input data for function at "
i have host group GGG and item already that gives me a numeric number from item `give_number` .........
Hello, how do I make a condition? for example:
count(last_foreach(/*/icmpping[{HOST.IP}])=0?[group="Printers"])
=0 or =1
Check out the documentation section regarding foreach function filters: www.zabbix.com/documentation/current/en/manual/appendix/functions/aggregate/foreach#item-filter
You should try and filter by host groups and/or tags to get the values that you're looking for.
@@zabbix
I'm having the same problem.
I think the manual is obfuscated or doesn't say what you're looking for.
>count(last_foreach(/*/icmpping[{HOST.IP}])=0?[group="Printers"])
Could you tell me the correct formula for this example?
How do I sum with for_each with filter of SSID that is unique. Example I have 10 clients connected to ssid_1, 5 to ssid_2, 1 to ssid_1 on same host. The summations would be 11 for ssid _1 for item.key.ssid[{#SSID}
will have to filter out Vlans/trunks so you dont sum more itens than you need.
what if i want create and array|table with values from hosts, not doing calculations?
just wanna pick all hosts with same itens and put in a table in grafana
Currently, the top hosts widget can analyze an item across different hosts and display it in a Top/Bottom hosts list, sorted by the item values. We also have plans to add a separate Top items list widget, which will provide a more general data table view of your items.
We can't really comment on Grafana, since they do things their own way by collecting values from Zabbix with Zabbix API calls and then aggregating the data for the visualization.
How to monitor paper (from printer) consumption in the form of a histogram (graph) by months and preferably get a summary of the average paper consumption by years (based on accumulated data)? Paper consumption counter data is logged.
You could use SNMP agent item and point it at the correct OID. The data could the be aggregated either by using a calculated item or directly in your Zabbix graphs.