[#ZBXNEXT-4033] Improve item type db.odbc.select: Return multiple columns (and rows) from SQL ODBC

[ZBXNEXT-4033] Improve item type db.odbc.select: Return multiple columns (and rows) from SQL ODBC Created: 2017 Aug 17 Updated: 2024 Apr 10 Resolved: 2019 Oct 02
Status:	Closed
Project:	ZABBIX FEATURE REQUESTS
Component/s:	Proxy (P), Server (S)
Affects Version/s:	None
Fix Version/s:	4.4.0beta1, 4.4 (plan)

Type:

Change Request

Priority:

Trivial

Reporter:

Rostislav Palivoda

Assignee:

Andrejs Kozlovs

Resolution:

Fixed

Votes:

Labels:

bulk, dependentitems, odbc

Remaining Estimate:

Not Specified

Time Spent:

Not Specified

Original Estimate:

Not Specified

Team:

Team A

Team:

Team A

Sprint:

Sprint 56 (Sep 2019), Sprint 57 (Oct 2019)

Story Points:

0.5

Description

The idea is to populate SQL results in to multiple dependent items in a single request.

In Zabibix 3.4 introduced

dependent items functionality (~~ZBXNEXT-3006~~) to reduce amount of calls for host metrics gathering.
JSON item values pre-processing (~~ZBXNEXT-3863~~)
In early version already available ODBC checks
documented at https://www.zabbix.com/documentation/2.4/ru/manual/config/items/itemtypes/odbc_checks

Comments

Comment by Glebs Ivanovskis (Inactive) [ 2017 Sep 06 ]

This request implies using JSON, ~~ZBXNEXT-4088~~ suggests CSV.

Comment by Oleg Ivanivskyi [ 2018 Oct 08 ]

Does it duplicate ~~ZBXNEXT-2307~~?

Comment by Andrejs Kozlovs [ 2019 Sep 20 ]

Fixed in:

Comment by Alexander Vladishev [ 2019 Oct 02 ]

Updated documentation

Generated at Sat Apr 20 00:27:45 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.