This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| configuration:monitoring:trigger [2019/07/22 10:50] – [Odbc] acruz | configuration:monitoring:trigger [2022/09/23 16:58] (current) – [Account Fire Events] admin | ||
|---|---|---|---|
| Line 72: | Line 72: | ||
| * Variables: Variable Text – Add (x2) | * Variables: Variable Text – Add (x2) | ||
| * Name: event_name; x – Expression : ^(register|unregister|expire)$ | * Name: event_name; x – Expression : ^(register|unregister|expire)$ | ||
| - | * Name: sensor_name; | + | * Name: sensor_name; |
| * Action: x – Custom: Alarm | * Action: x – Custom: Alarm | ||
| * x – Custom | * x – Custom | ||
| 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 ==== | ||