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

Macro support in SQL queries of Database monitor items

    Details

    • Type: Change Request
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.2.10
    • Fix Version/s: None
    • Component/s: Proxy (P), Server (S)
    • Labels:

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              okkuv9xh Marc
            • Votes:
              7 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: