Help getting SQL Query for Item

[jamesaphaigh]

I'd be really grateful for some assistance as I think I've hit a dead end and what I though would be a 'relatively' simple task.

We run an osTicket helpdesk (in a MariaDB database) and I wanted to get the current ticket counts (open, pending etc.) to display on our zabbix dashboard. Simple,...

[jurgen16]

Hello,

How much ODBC pollers should have for monitoring around 20 DB's because I am reaching this trigger: Utilization of ODBC poller processes over 75%, when 2 of them goes down. In that case the trigger is raised and I am receiving from all DB's the trigger "Failed to fetch info...

[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...

[bnerusil]

Hi
I would like to kindly ask for your help,

I am struggling with monitoring these three things via MSSQL by ODBC template:

1. MSSQL: Get Buffer Manager counters: MSSQL: Buffer cache hit ratio – I received: status not supported - info - Preprocessing failed for: [{"object_name":"SQLServer:Buffer...

[solaireofastora]

How can the trigger Oracle Database '{#DBNAME}': Open status in mount mode work if, when the database is in the mounted status, the session cannot log in to the database? All items (including Oracle Database '{#DBNAME}': Open status item ) receive the following error:

Cannot connect to...

[robert.ortel]

Hi,

I want to do some oracle checks using odbc on ASM instances (login as sysdba) and mounted physical standby databases (login as sysdg). But using zabbix odbc based checks I do always fail to login with this error:


Cannot connect to ODBC DSN: [SQL_ERROR]:[28000][1017][[Oracle][ODBC][Ora]ORA-01017:...

[markfree]

I set up a Proxy 6.2 with ODBC for an Oracle DB.
The connection is running and I can collect some data from the DB.

I can test the connection using iSQL and it works fine at the command line.

$ isql [dsn] [user] [pass] -b << EOF
select count(*) from GENESYS_[dsn].TABLE;

...

[La Su]

Information:

Integration with MSSQL by ODBC DB Template
https://www.zabbix.com/br/integrations/mssql

ubuntu 20.04 in Virtual BOX Mode Bridge

Microsoft ODBC Driver for SQL Server (Linux - Ubuntu) - ms odbc 18
https://docs.microsoft.com/en-us/sql/con...

[thiomed]

Hello everyone, hope you doing good,
I'm new in monitoring and i start using zabbix, i found it usefull and i want to monitor microsoft sql server using zabbix but whene i add the MSSQL BY ODBC themplate i didn't get any information my server, and everything is configured right i'v trying a week...

[clauclauds]

So i am trying to monitor oracle database replication using zabbix,
my setup is:

1. oracle database 11g r2
2. zabbix 5.4

i did install ODBC client in zabbix server and follow this step, my zabbix server can connect with my oracle database via ODBC. But, when i add template 'Oracle Database by ODBC'...

[cyberphantom]

Olá
Estou estudando mais sobre o Zabbix e possuo básico conhecimento em banco de dados... Contudo, preciso fazer uma configuração para que o Zabbix se comunique com o banco Oracle, via ODBC. Fiz as configurações seguindo vários tutoriais e também a documentação (https://www.zabbix.com/documen...

[betterdc]

Do you have a way to solve this problem??
3Q!!
----------------
vi /etc/odbc.ini

[test]
Description = MySQL test database
Driver = mysql
Server = 127.0.0.1
User = root
Password =
Port = 3306
Database...

[ulrich_mueller]

Hello everybody,

how can I process data in tables in a database that are used for logging purposes?

The table usually consists of a timestamp, severity and message.

With "db.odbc.getdb" I can get json but
* How to get the last unprocessed lines?...

[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:

...

[clauclauds]

I install ODBC to monitoring Oracle Database via Zabbix, but I got error :



I did everything on tutorial, here's my config :

/etc/odbcinst.ini :

[OracleDriver]
Description=Oracle ODBC driver for Oracle 11g
Driver=/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1

...