Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
configuration:monitoring:trigger [2019/07/22 10:50]
acruz [Odbc]
configuration:monitoring:trigger [2019/07/23 10:18]
acruz [Odbc]
Line 188: Line 188:
  
 ==== Odbc ==== ==== Odbc ====
 +Adding a trigger rule that check status as account '​example'​ in odbc query:
   * Name: odbc_query   * Name: odbc_query
   * Priority: First   * Priority: First
Line 194: Line 195:
   * Action: x - Custom, odbc   * Action: x - Custom, odbc
     * ODBC: triggers.     * ODBC: triggers.
-    * SQL: select * from accounts where status ​= 'down';+    * SQL: select * from accounts where name  ​= 'example'; 
 + 
 +Adding a trigger rule that check response of the query and send one email to responsable:​ 
 +  * Name: check_odbc_query 
 +  * Priority: After: odbc_query 
 +  * Continue: Continue after rule 
 +  * Conditions: x - custom 
 +    * vairables main value: 
 +       * name: odbc_status  
 +       * Expresion: '​down'​ 
 +  * Action: x - Custom, email 
 +    * to: ${odbc_responsable}. 
 +    * subject: ${odbc_name} account is down 
 +    * body: check status of your account ${odbc_name} because is down  
 ==== Attendance ==== ==== Attendance ====
  
/home/www/wiki/data/pages/configuration/monitoring/trigger.txt · Last modified: 2019/07/23 10:18 by acruz
 
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki