Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
configuration:monitoring:trigger [2019/07/22 10:50] – [Odbc] acruzconfiguration:monitoring:trigger [2019/07/23 10:18] – [Odbc] acruz
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: 2022/09/23 16:58 by admin
 
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki