Thanks to ZBXNEXT-1633 Zabbix can easily connect to other monitoring systems to dynamically obtain data from entities monitored by these systems.
With most item types this works quite well but the ODBC type is one where it doesn't.
Discovery of monitored entities to create a Zabbix host for each entity is generally no issue:
SELECT hostname FROM monitored_entities
But I don't see any way to use ODBC items for discovered hosts:
SELECT value FROM metrics WHERE name = 'Metric' AND monitored_entity = {HOST.HOST}
Therefore it would be pretty nice to have a way to use variable information in SQL queries of ODBC monitoring supplied by Low-Level-Discovery.
Of course, there might be other valid use cases as well.