How to store the details of SQL Server sessions with sp_whoisactive in Zabbix?

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

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

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

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

[xrodriguez]

Hola.

Estamos detectando un problema a la hora de monitorizar SQL Servers con la plantilla https://github.com/MantasTumenas/Zab...oft-SQL-Server
No sabemos si es un problema de PowerShell o es una mala configuración del agente de Zabbix.

La plantilla hace LLD para bases...

[rburkholder]

I am trying to run the following query from a database monitor item in Zabbix. The query returns the last run date of the specified job as a unix timestamp. The database monitor item keeps becoming unsupported with the following error "cannot fetch row:[SQL_ERROR]:[22003][0][[Microsoft][ODBC Driver...

[abovebeyond]

Hi ,

just downloaded the template:
Template_MicrosoftSQLServer_Multi_Instance

Tried to configure it without a success, i will be happy for help to configure it right

Thanks!

[mapsv3]

In a project, user will key in data in a software and data will be export into SQL Server 2008 R2

Once SQL Server identify there is an inserted data (new row), it will trigger code to update table Abbyy base on business rule.

In table Abbyy, its contain column
...

[clubbing80s]

Hi.

I want to get a list of metrics that the zabbix_agent is aware of on a windows server , for both the OS and applications. eg: MS SQL, Exchange, Terminal server.

I have tried the zabbix_agentd --print but the list seems shorter that what I have seen that last time I...