ZABBIX discovery rule for mysql
Two level discovery Create discovery rules Type: database monitoring key: db.odbc.discovery[daily_sales,db_qa_masqa_3306] SQL: select term_no as TERMNO ,sum(amount) as AMOUNT from p_trx where trx_date > curdate() group by term_no item prototype Name: Daily sales term 2: {#TERMNO} Type: Database monitoring key:db.odbc.select[sales{#TERMNO},db_qa_masqa_3306] Read More