[ZBXNEXT-4088] Ability to get full result of ODBC SQL query Created: 2017 Sep 06  Updated: 2020 Jan 08  Resolved: 2019 Sep 19

Status: Closed
Project: ZABBIX FEATURE REQUESTS
Component/s: Server (S)
Affects Version/s: 4.0.0alpha1
Fix Version/s: None

Type: New Feature Request Priority: Major
Reporter: Glebs Ivanovskis (Inactive) Assignee: Andris Zeila
Resolution: Duplicate Votes: 3
Labels: bulk, odbc
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by ZBXNEXT-4683 Change ODBC LLD discovery to use {#<j... Closed
Sub-task
depends on ZBXNEXT-3970 Extend item preprocessing with CSV pa... Closed
part of ZBXNEXT-4086 Extend item preprocessing with functi... Closed

 Description   

Currently db.odbc.select returns only first column of the first row. Would be nice if it could return the whole SQL query result together with column names.

Together with ZBXNEXT-3006 it will reduce amount of queries needed to monitor databases.

 Comments   
Comment by Oleksii Zagorskyi [ 2017 Sep 06 ]

Could be ZBXNEXT-4033 related?

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

Indeed. The only difference I see, ZBXNEXT-4033 implies using JSON. So, technically, not a duplicate.

Comment by Rostislav Palivoda [ 2019 Sep 09 ]

Please follow ZBXNEXT-4033

Generated at Thu Apr 25 12:12:14 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.