odbc.get columns are reordered after jsonpath preprocessing

[Ace]

Hello,

I use odbc.get to get a list of 6 columns (ID, SUB_ID, TYPE, STATUS, NAME, CATEGORY) and then use JSONPATH preprocessing on a dependent item to filter out some of the results by TYPE:

$[?(@.TYPE=='XXXX' || @.TYPE=='XXXX')]

The problem is the ordering of...

[ZabbixMike]

I spent hours troubleshooting then realised that it was installing all of the addons broke the Zabbix agent 2 service, choosing only MSSQL doesn't brake the service which is all I need anyway.

Its been installed on our test servers but I need to deploy this to over 100 servers so need to...

[ZabbixMike]

I've spent 2 days on this and installed/uninstalled close to 30 times and Zabbix just keeps breaking.

I'll explain the steps I've been using

- I've installed agent2 on the server.
- I've already configured the host in Zabbix so it pulls metrics from the server like CPU,...

[amazzucchelli]

Hi, how can I create an alert that shows me when a Database Log FILE reachs a defined size? For example, I want to know when the .ldf file from ANYDATABASE reachs 10 Gbs?

I could create a Trigger/Item and Macro that alerts me when ALL .ldf files from ALL databases together reachs 10 Gbs,...

[hammyhabib]

Hi ,
Thank you all for your up coming help on the subject, and please my post format as this is my first time to post here.
In my work I have to setup supervision on Windows SQL Server machines using Zabbix. I've installed the ZABBIX AGENT 2 (V 6.4.20) and the MSSQL plugging (same version)....

[diegoalexander59]

I need to know how to store session details in SQL Server, storing the time of data collection, hostname, username, query and information if it is blocking other sessions.
I would like to be able to see in the selected time range all the queries that were captured. I don't know if it is possible...

[PiotrJ]

Hi
I'd like to do a table on my dashboard where i can see which backup (job) failed.
Database is on virtual machine in the same network with zabbix and its on MSSQL.
Zabbix is on another virtualmachine with debian and its by the docker compose.
Now i want cojnect database with...

[rooten1981]

Hi,

I'm trying to monitor a MSSQL instance using the MSSQL BY ODBC template.

The ODBC driver has been installed and configured,i'm able to fetch data , but for some reason,some of the metrics does not show up.




The error message is the same...

[ekholve]

I am trying to evaluate the stock mssql_odbc template to monitor Microsoft SQL Server instances.

Zabbix server version:
zabbix_server (Zabbix) 5.2.5

I am using Zabbix Agent 2 (but have also Zabbix Agent 1 on other server)

The template should be able to monitor...

[schieber]

Hello guys,

My company is implementing Zabbix on a test/PoC environment and currently we are stuck at this error:

bash-5.0# isql MSSQL sa <password> -v
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib64/libtdsodbc.so.0' : file not found
[ISQL]ERROR:

...

[Avi]

Hi,

After configuring the MSSQL ODBC template on Zabbix 5.2 to Monitor Azure SQL Server, we are stuck with the following errors in the Zabbix server logs (same errors are reported on UI as well):

From Zabbix Server Logs:
1. Failed: cannot extract value from json by path...

[maand]

Hi,
I have extended the official Template DB MSSQL by ODBC to discover agent jobs and triggers for failed jobs with the same structure as the rest of the template and are also going to extend it with discover backups.

Is this something that i can send to Zabbix team somehow to see...

[ideschamps]

Hi,

We are running v5.02 of Zabbix server and Zabbix Proxy. All working good. We now want to monitor our SQL 2017 server which only has Integrated Authentication available and not SQL login/auth. I have followed all the instructions here https://git.zabbix.com/projects/ZBX/...odbc/READ...

[dotup.de]

Unfortunately, the already existing templates didn't work for me. So I wrote another one.

A little howto is in the readme file.

Repository:
https://github.com/dotupNET/dotup-za...e-mssql-backup

Meine Notizen von der Installation:
https://blog.dotup...

[Mikooo]

Hello,

since few days I'm struggling with mechanism which monitors datafile usage - via ODBC (without creating anything localy on host.. everyting has to be done from Zabbix Server - query etc.).

So far I invented 3 items which gives me results like:

Item...