This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
configuration:monitoring:trigger [2019/07/22 10:50] – [Odbc] acruz | configuration:monitoring:trigger [2019/07/23 10:18] – [Odbc] acruz | ||
---|---|---|---|
Line 188: | Line 188: | ||
==== Odbc ==== | ==== Odbc ==== | ||
+ | Adding a trigger rule that check status as account ' | ||
* 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 | + | * SQL: select * from accounts where name |
+ | |||
+ | 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} account is down | ||
+ | * body: check status of your account ${odbc_name} because is down | ||
==== Attendance ==== | ==== Attendance ==== | ||