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

[WirelessGuru]

Hello,

I have tried everything with housekeeper and adjusting items in the server conf file. I went from 90d history to 30d both adjusting individual items and even override global settings and still the database just continues to grow.

I occasionally get the following message...

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

[arktoday]

I have custom template with attached template PostgreSQL by Zabbix agent 2. There is an Item with key pgsql.custom.query. But I can't edit item key in new custom template.




How can I edit it (item key) only for custom template? Or how to add new custom query?
...

[DanielGarzaF]

Im trying to monitor SQL databases and custom querys with zabbix, testing with SQL users works just fine but i cant find a way to make it work with windows authentication user

Anyone have any tips? due to some security rules most of our DBs are only accesible trough this type of users

[kapi]

Hi
i want to adapt this script (zabbix 2.0) to zabbix 1.8

(SELECT g.name AS HostGroup, h.name AS Host, s.ip AS IpAddress, t.description AS Problem, FROM_UNIXTIME(e.clock) AS DataEvento
FROM triggers t
INNER JOIN functions f ON ( f.triggerid = t.triggerid )
INNER...

[JakobHannibal]

I want to read data from SQL databases via the "userparameter configuration file".

In this file I have multiple lines like this:

#UserParameter=get.MY_SQL1[*], "C:\zabbix\SQLCMD\sqlcmd.exe" -S "database server" -d "databasename" -U "user"...

[jlord87]

Hi everybody,

I'm trying to monitor performance of some Azure SQL instances with the latest Zabbix server v 5.x.
I was trying to follow the Official Microsoft SQL integration doc, but in Azure View Server State and View Any Definition permissions are not supported.

How...

[brenoacp]

Hello everyone!
I am performing a query in the Items table, and the name of some items is displayed for example:

"Outgoing network traffic on $1"
or
"Free disk space on $1".

Where is the value of these variables stored?
Please, could...

[chkhartishvili]

Здравствуйте!
Задача состоит в мониторинге счетчика производительности "\MSSQL$MSSQLEVAL:Buffer Manager\Коэффициент обращений к буферному кэшу"
Выдает значение команда,...

[yishai8]

Hi,

I'm running a 2 steps discovery:

1) SQL query runs on the server( where the agent is) and sends a json using zabbix sender to zabbix where a trapper catches it.
2) LLD uses the JSON values as parameter to run another script (userParameter is configured) with another...

[atraides]

Добрый день, уважаемое коммюнити заббикса, подскажите пожалуйста, есть задача получить с помощь 1 sql запроса на вывод некую таблицу с именем хоста и последним значением...

[TheLion]

It's seem to be a simple task, but I can't figure it out.
I want to create table with a item name and it's related triggers' lastchange value, I've tried using the functions table to relate my query but it results 0 rows. What am I doing wrong?

SELECT
  t1.name as "Arquivo",

...

[jm123]

I'm working on calculating transfer values and throughput values +95ths and I'm having a hell of a time figuring out how zabbix is storing the things. Anyone have a part in this? It seems like chaos in the Database, but I trust the front end got it correct with the graphs.

I'm gonna work...

[lym1021]

everything works fine before its spawning lots of requests like this
SELECT dv.mandatory,dv.optional FROM dbversion dv
with status Opening tables.
and its stops working