Details

    • Type: New Feature Request
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.3
    • Fix Version/s: 2.5.0
    • Labels:
    • Environment:
      Centos 6.5, Oracle Instant Client, unixODBC

      Description

      Please add LLD Discovery Item to ODBC:

      db.odbc.discovery[name_of_select,DSN]

      Query in item must return table.

      The table must be converted to JSON array, each column name is a filed in JSON array.

      For example: Oracle get jobs list:

      SELECT job_name, owner FROM dba_scheduler_jobs WHERE state != 'DISABLED';

      will return table:

      +-------------------------------+-------------------------------+
      | JOB_NAME                      | OWNER                         |
      +-------------------------------+-------------------------------+
      | PURGE_LOG                     | SYS                           |
      | ORA$AUTOTASK_CLEAN            | SYS                           |
      | DRA_REEVALUATE_OPEN_FAILURES  | SYS                           |
      | BSLN_MAINTAIN_STATS_JOB       | SYS                           |
      | RSE$CLEAN_RECOVERABLE_SCRIPT  | SYS                           |
      | SM$CLEAN_AUTO_SPLIT_MERGE     | SYS                           |
      | RLM$EVTCLEANUP                | EXFSYS                        |
      | RLM$SCHDNEGACTION             | EXFSYS                        |
      | GATHERSTATS_9725482           | DOCSDBADM                     |
      | MGMT_STATS_CONFIG_JOB         | ORACLE_OCM                    |
      | MGMT_CONFIG_JOB               | ORACLE_OCM                    |
      | J_SEARCH_CONTRACT             | EPZ_CONTRACT_SEARCH           |
      | J_SEARCH_PLAN_GRAPH           | EPZ_PLAN_GRAPH_SEARCH         |
      +-------------------------------+-------------------------------+
      

      this table must be conveted to

      {"data":[{"{#JOBNAME}":"SM$CLEAN_AUTO_SPLIT_MERGE","{#JOBOWNER}":"SYS"},{"{#JOBNAME}":"RSE$CLEAN_RECOVERABLE_SCRIPT","{#JOBOWNER}":"SYS"},{"{#JOBNAME}":"BSLN_MAINTAIN_STATS_JOB","{#JOBOWNER}":"SYS"},{"{#JOBNAME}":"DRA_REEVALUATE_OPEN_FAILURES","{#JOBOWNER}":"SYS"},{"{#JOBNAME}":"ORA$AUTOTASK_CLEAN","{#JOBOWNER}":"SYS"},{"{#JOBNAME}":"PURGE_LOG","{#JOBOWNER}":"SYS"},{"{#JOBNAME}":"MGMT_CONFIG_JOB","{#JOBOWNER}":"ORACLE_OCM"},{"{#JOBNAME}":"MGMT_STATS_CONFIG_JOB","{#JOBOWNER}":"ORACLE_OCM"},{"{#JOBNAME}":"RLM$SCHDNEGACTION","{#JOBOWNER}":"EXFSYS"},{"{#JOBNAME}":"RLM$EVTCLEANUP","{#JOBOWNER}":"EXFSYS"},{"{#JOBNAME}":"GATHERSTATS_9725482","{#JOBOWNER}":"DOCSDBADM"},{"{#JOBNAME}":"JOB_INS_SEARCH","{#JOBOWNER}":"ZAKUPKI_DEV"},{"{#JOBNAME}":"JOB_PGP_SEARCH","{#JOBOWNER}":"ZAKUPKI_DEV"},{"{#JOBNAME}":"JOB_UNSCHED_INS_SEARCH","{#JOBOWNER}":"ZAKUPKI_DEV"},{"{#JOBNAME}":"JOB_PLAN_GRAPH_EPZ_UPDATE",{"{#JOBNAME}":"J_SEARCH_CONTRACT","{#JOBOWNER}":"EPZ_CONTRACT_SEARCH"},{"{#JOBNAME}":"J_SEARCH_PLAN_GRAPH","{#JOBOWNER}":"EPZ_PLAN_GRAPH_SEARCH"}]}
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              nucleusv Vadim Nesterov
            • Votes:
              6 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: