create graph with a query output

[BlackCrystal]

hi. can i use a query to create graph in zabbix 3.4?
i have this userparameter:
UserParameter=db.bksize,echo "select bksize from BACKUP where date=current date "
it returns about 39 values.
can i use this 39 values to create graph instead of creating 39 items?
if this is possible how can i use it in web zabbix?

[DmitryL]

Long story short - It is not possible to pass an array of data to single item.
Advice:

Create LLD for database discovery - looks like there will be unique identifiers like backup_id or something like that.
Based on an item prototype create separate items for each backup type.
Same story with triggers.

[BlackCrystal]

LLD? you mean i create a discovery that generate 39 items then use them on graph?

[DmitryL]

Exactly.

https://www.zabbix.com/documentation/4.0/manual/discovery/low_level_discovery/sql_queries