Count Zabbix Items per host/hostgroup

[jefersonantonio]

Hi,

How can i count the numbers of items per host/hostgroup? Is it possible?

For example, i have this items below and i need the sum of this items

Item example 1 - (23)
Item example 2 - (5)


sum=28

You can find more info the image attached.

[batchenr]

Hi,

How can i count the numbers of items per host/hostgroup? Is it possible?

For example, i have this items below and i need the sum of this items

Item example 1 - (23)
Item example 2 - (5)


sum=28

You can find more info the image attached.

yes,

go to zabbix GUI-> Configuration -> Hosts
at the host screen you will see all ur host and there item
choose one host and press on its items tab
then you will get to 'item' screen

there in the filter delete the host name
and in Name chose the item you want to count name or key under
key filter

[jefersonantonio]

Thanks batchenr!
How can i do that by sql(mysql)? Do you know?

[batchenr]

Thanks batchenr!
How can i do that by sql(mysql)? Do you know?

Hey yes-
what i did to get it is to run :

watch "mysql -e \"SELECT COMMAND,TIME,STATE, INFO  FROM information_schema.processlist WHERE COMMAND='Query'\""

and then run the search and see how zabbix run it in the DB.



the quary should be : change '%ITEM.NAME%' to your item name.

use zabbixdb;

SELECT i.itemid,i.type,i.hostid,i.name,i.key_,i.delay,i.history,i.trends,i.status,i.value_type,i.error,i.templateid,i.flags,i.state FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND ( (  UPPER(i.name)  LIKE [B]'%ITEM.NAME%'[/B] ESCAPE '!' ) ) ORDER BY i.status LIMIT 1001 OFFSET 0;

[janssenreis]

Better to use an API than to do SQL queries.

https://www.zabbix.com/documentation/3.2/manual/api/reference/item/get

[Rudlafik]

{
"jsonrpc": "2.0",
"method": "host.get",
"params": {
"output": ["hostid"],
"groupids": "No of Host Group",
"countOutput": true
},
"auth": "Your Auth Key",
"id": 1
}