This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
| configuration:monitoring:trigger [2019/07/22 10:50] – [Odbc] acruz | configuration:monitoring:trigger [2019/07/22 10:59] – [Odbc] acruz | ||
|---|---|---|---|
| Line 188: | Line 188: | ||
| ==== Odbc ==== | ==== Odbc ==== | ||
| + | Adding a trigger rule that check status as lines 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 | + | * SQL: select * from lines where status = ' |
| + | |||
| + | 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: ' | ||
| + | * Action: x - Custom, email | ||
| + | * to: ${odbc_responsable}. | ||
| + | * subject: ${odbc_name} line is down | ||
| + | * body: check status of ${odbc_name} because is down | ||
| ==== Attendance ==== | ==== Attendance ==== | ||