[ZBXNEXT-2913] Macro support in SQL queries of Database monitor items Created: 2015 Aug 20 Updated: 2015 Aug 21 |
|
Status: | Open |
Project: | ZABBIX FEATURE REQUESTS |
Component/s: | Proxy (P), Server (S) |
Affects Version/s: | 2.2.10 |
Fix Version/s: | None |
Type: | Change Request | Priority: | Minor |
Reporter: | Marc | Assignee: | Unassigned |
Resolution: | Unresolved | Votes: | 9 |
Labels: | item, lld, macros, odbc | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Description |
Thanks to 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. |
Comments |
Comment by Oleksii Zagorskyi [ 2015 Aug 21 ] |
Similar question was asked in ZBX-5521 And see similar issue (support host macros in item keys) in ZBXNEXT-2896 |