Table monitoring

[ninguno]

Hi, I'm new here. I'm testing Zabbix to see if can help me monitoring my environment and up to now it seem it's the right choice!

I have one question, one of needs is querying some database application tables to collect data, analyze results and trigger alarms/actions across time;
for eg a SELECT COUNT(*) FROM CUSTOM_TABLE that is trigger every 15 minutes, and if the value return is < 10, send an email.

Is it possible to do this? What is the best way to achieve it? Is there any database template available to make querys specifying database connection parameters and a query and collect the results in the form of field1=value1...?

I saw here http://www.zabbix.com/forum/showthread.php?t=9647 and approach using a command line script, but I want to know if there is anything more "user-friendly".

Thanks in advance!!!

[ninguno]

Anyone?

[richlv]

you should probably use userparameters - see http://www.zabbix.com/documentation/...ser_parameters

you can make them accept parameters, for example, table names.

in the zabbix source archive there's an example file userparameter_mysql.conf - you could take a look at that for inspiration

[ninguno]

Thanks rich, I'll look at them.

I also see that I could use "Database monitoring" Item type, I think that I could get it working also with one of them.