|
Aim
In this example, we will retrieve the list of registered RSMs in our BMC Portal configuration and trigger an alarm when one of them fails (i.e. its status is neither ONLINE, nor DISABLED). We will interrogate BMC Portal’s DataStore (an Oracle database) in order to get this information.
Procedure
| 1. | Add a new “SQL Query – Oracle” class: |
| ▪ | Enter the credentials to connect to BMC Portal’s DataStore (pe/pe by default) |
| 2. | Add a new SQL query instance: |
| ▪ | Specify the following SQL query: SELECT * FROM agent |
| 3. | Add a new String Search: |
| ▪ | Search for lines that match with [CRITERION 1] and [CRITERION 2] |
| ▪ | [CRITERION 1]: Line must NOT contain “ONLINE” in the 8th column, case insensitive |
| ▪ | [CRITERION 2]: Line must NOT contain “DISABLED” in the 8th column, case insensitive |
| ▪ | Column separator: semicolon |
| ▪ | Alert thresholds on either the “Matching Lines” (Regular Expression Threshold .*) or the “Matching Line Count” parameter (alarm is greater than or equals to 1) |
|
