I want to monitor the data on Microsoft sql server database using Zabbix. for example, in table T1 containing columns col1, col2, col3, when the value of col1 is less than 0 it should notify me. Due to the security reason I cannot install agent on the database host. I want to know how can I monitor this database without installing Zabbix agent on its host?

CodePudding user response：

You can use ODBC monitoring, described in here.

The template already has standard items preconfigured, you must add your customizations: your item will be a SELECT statement, your trigger will react to the returned value.

You can also find 3rd party stuff in the second tab or in Zabbix Share.