Hi all!
We use Zabbix 4.0 for monitoring large infrastructure with hundreds of servers, routers, vm's, etc. We need to automatically change triggers expressions on some servers when some data changes.
Who knows, how the database tables `hosts` and `triggers` are connected together? By what keys? What do the numbers in {braces} mean at the `triggers`.`expression` field?
All database schemas from internet are for older versions and I don't find answers on it.
For now, the only possibility what I see is manually record the info about the `host` to the, e.g., `triggers`.`comments`. But I would like to use a more elegant solution.
And about braces in `expressions`. Is it possible to correlate these {numbers} in expressions? Can I add a trigger directly to the database by INSERT INTO `triggers` without the Zabbix web interface?
Thanks.
We use Zabbix 4.0 for monitoring large infrastructure with hundreds of servers, routers, vm's, etc. We need to automatically change triggers expressions on some servers when some data changes.
Who knows, how the database tables `hosts` and `triggers` are connected together? By what keys? What do the numbers in {braces} mean at the `triggers`.`expression` field?
All database schemas from internet are for older versions and I don't find answers on it.
For now, the only possibility what I see is manually record the info about the `host` to the, e.g., `triggers`.`comments`. But I would like to use a more elegant solution.
And about braces in `expressions`. Is it possible to correlate these {numbers} in expressions? Can I add a trigger directly to the database by INSERT INTO `triggers` without the Zabbix web interface?
Thanks.