Home > Alerts > Configuring Alerts > Configured Alerts

Configured Alerts

To configure the different alerts open a web browser to http://localhost:8080/AlertEngine.

The home page for this application is the Configured Alerts page.

http://tomcat.apache.org/

Figure: Example Configured Alerts Screen

This page shows a list of all alerts configured in the application. To edit an alert click on the ID or Description in the table; to delete an entry click the button at the end of the row. A report can be generated by clicking the manual run alert icon on the row.

Note: You can also change the sort options for the table by clicking on a column header. The green arrow indicates whether sorting on the column is currently ascending or descending.

You can add a new alert by clicking the Add button underneath the table and manage the portal definitions by clicking on the View / Edit Portals button at the end of the page (see Portals for more information on managing portal definitions).

Add/Edit Alert

This page shows the alert properties (ID, description, SQL query text, Active flag) and also summary lists of the schedules, and result exports configured for the particular alert.

Figure: Adding or Editing An Alert

Each alert can contain several schedules – each time one is fired the SQL statement is executed and the results are passed to each of the Result Exports defined for the alert.

The SQL may contain special tokens which will be replaced before the query is executed:

• <LASTRUN> - This is replaced with the date / time that the alert was last executed. This value is stored in memory only so when the application is started the current date / time is used.

• <NOW> - The current date and time.

• <TODAY> - 00:00:00 on the current day.

Testing Database Queries

You can verify the query entered is a valid SQL statement and that the results returned are valid for the type of export intended using the test database query function. Underneath the SQL input text area is a link to the test page. When this link is clicked a new window is shown with the entered SQL query in the text input area.

Figure Test Database Query Screen

When you click the Test Query link button the results are shown in the 2 text areas below the SQL query input area. The first output text area (Results) will show the number of rows and number of columns returned, followed by the column names in order (comma-separated). The second output area (Values) will show the actual values returned for each row – however, if the query returns more than 100 rows or the values string grows to longer than 2000 characters, the output string will be truncated.

When you click Return to return to the editing alert screen, the value entered for the SQL query will be copied into the current alert being edited.