Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-2913

Macro support in SQL queries of Database monitor items

XMLWordPrintable

      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.

            Unassigned Unassigned
            okkuv9xh Marc
            Votes:
            9 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated: