Low level discovery at database monitor not supported

[[email protected]]

Hi,

I've some problems with LLD rule configuration. I try to configure rule over database connection as below picture shows



SQL query

select '{ '||chr(10)||chr(9)||'"data":['||chr(10)||chr(10)||chr(9)||chr(9)||' { "{#TBNAME}":"SYSTEM" } '||chr(10)||chr(10)||chr(9)||']'||chr(10)||'}'||chr(10) as dat from dual

used in example produce output in JSON format as below



After all this discovery rule still stays in not supported state.



There is no information in log (even in debug mode).
Has anybydy got an idea what is wrong in this case or where can I find information about problems in my zabbix instance?
In addition I can say that LLD in java templates based on zabbix trapper work fine.

[[email protected]]

Found solution

Problem was in key item. Should be db.odbc.select[....].
It's working.