How to sum values from discovery items?

[gumis_148]

I have discovery item with key:

backup.userdatabasefull.mssql.status[{#SQLINSTANCENAME},{#DBNAME},{$UDBFTIME1},{$UDBFTI ME2},{$UDBFTIME3}]

I would like to have a sum of all discovery items.

I tried with Zabbix aggregate:

grpsum[SQL,"backup.userdatabasefull.mssql.status[{#SQLINSTANCENAME},{#DBNAME},{$UDBFTIME1},{$UDBFTIME2},{$UDBFTIME3}]",last]

but I get:

No items for key "backup.userdatabasefull.mssql.status[MSSQLSERVER,MyDB,24,48,72]" in group(s) "SQL".

Host is in SQL's group.

[gumis_148]

how do you plan to sum values like "MSSQLSERVER,MyDB" ?

I have 50 databases. I don't want to receive 50 alerts about problems with backup. If there is no backup of 50 databases, there is probably a problem with the database server, inaccessibility, etc. Therefore, it is a good idea to send one alert, such as over 30 databases, without making a backup.
The value from the above template with a backup older than 24h is 7, so you can sum all (50 * 7) or values and then send one alert (e.g. trigger:> 350).

[cyber]

how do you plan to sum values like "MSSQLSERVER,MyDB" ?
grpsum summarizes values of similar keys in hostgroup.... and you do not have such keys. You should try aggregate items for things that can be summarized...

https://www.zabbix.com/documentation/current/manual/config/items/itemtypes/calculated/aggregate