We need to monitor a database table for response time of an action within our system. If the response time is above a threshold, we need to send an alert with details of the action: action_type, action_name, and others.
Is this possible with Zabbix?
I tried creating a Database monitor item with the following sql:
select action_type, action_name, window_title, response_time from db.table order by action_timestamp desc limit 1;
I was hoping that Zabbix would be able to store and display all the fields in the select, but it just gets the first value (action_type) and not all the fields.
Is there another way to do it, with Zabbix? It's pretty much a must for us so if we can't do it we won't be able to use Zabbix.
Thank you for your help, everyone.
Is this possible with Zabbix?
I tried creating a Database monitor item with the following sql:
select action_type, action_name, window_title, response_time from db.table order by action_timestamp desc limit 1;
I was hoping that Zabbix would be able to store and display all the fields in the select, but it just gets the first value (action_type) and not all the fields.
Is there another way to do it, with Zabbix? It's pretty much a must for us so if we can't do it we won't be able to use Zabbix.
Thank you for your help, everyone.