-
New Feature Request
-
Resolution: Fixed
-
Major
-
2.2.3
-
Centos 6.5, Oracle Instant Client, unixODBC
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"}]}